Copy email before sending into a database

  • Thread starter Thread starter itsyash
  • Start date Start date
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
 
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
 
Back
Top