How do I automatically export emails into CSV and send out reply?

[fred_easey]

Hi,

I need to write a VB script that will automatically check emails in an outlook email account, send a reply to each one (generic message each time) and then save the sender's email to a csv list stored on a specified path (eg <\\somedir\>).

This script is required to manage unsubscribes from a web page-based competition (so there is an email address that users email to request to unsubscribe from the competition and I need all of those emails replied to and the senders email stored in the csv for processing).

Anyone know how to do this?

Any help much appreciated,

Cheers,

Fred

[Static]

Do you have VB6 or VB.net?

your best bet would be to write an Outlook Add-in.. and Add-in can catch all sorts of events and do everything needed without having the security prompt appear.

[fred_easey]

Hi,

I have VB6. Add-in sounds like a good idea. Not sure where to start though. ave you got any pre-canned code I can adapt?

Also, how do I use add-ins for outlook, is there a good FAQ you could point me to?

Cheers,

Fred

[Static]

google it.. there are lots of samples out there..
but to start:

Start a new project.. pick Add-In

then switch to the Connect.dsr (object view)
and select Outlook in the application
and Startup in the load...

here is a sample project that copies the domains to the junk sender and deletes
http://www.freevbcode.com/ShowCode.Asp?ID=5937
but dig around.. there are lots.

if you need help.. we're here :)

[RobDog888]

Here is one way for a basic AddIn.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon98/html/vbconaddinessentials.asp

[fred_easey]

Cheers guys, I'll take a look at these tomorrow :)

(11pm here)