Copy email before sending into a database

I

itsyash

Hi,

I have worked on excel macros but outlook looks entirely different....

I have a set of users in my company using outlook 2003. When they send
an email, i need to export a few fields like -- to: , bcc: cc: sent,
body etc into a SQL database.

Can anyone help me with the code?

Thanks,
Yash
 
E

Eric Legault [MVP - Outlook]

Have you started writing the code?

Basically you need to trap the MailItem_Send event, and read the
MailItem.To, MailItem.Cc and MailItem.Bcc properties. Your database code is
entirely up to you and is out of scope for this forum.

For help with trapping events, see my blog article:

Eric Legault My Eggo : Getting a Handle on Your E-mails with VBA:
http://blogs.officezealot.com/legault/pages/20086.aspx
 
Top