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

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

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.

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

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 :)

Here is one way for a basic AddIn.

http://msdn.microsoft.com/library/de...essentials.asp

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

(11pm here)