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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sending mails from Excel 2003 - Outlook signature 7
VBA Outlook 2003 - Sending mails from Excel 2003 2
Export email from Outlook into Access... 3
email from excel cell 1
Send email using spreadsheet 7
Sending e-mails from specific email address 2
To: or CC: or BCC: 4
Checking Recipient Group before sending email via VBA 2

Top