Is this possible (Grab Outlook data from MS Access)?

[Dmitry Streblechenko]

Use Application.ItemSend event to process the outgoing messgaes.

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-

 

[Dorian]

I have a need to do the following.
When Outlook is open and an email has been composed and is ready to send ...
in another application (MS Access), I need to somehow get the to: and cc:
values from the Outlook email into my Access database (using VBA).
Does anyone know if this can be done?
Thanks for any possible tips.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[oshosoul]

I have a need to do the following.
When Outlook is open and an email has been composed and is ready to send ...
in another application (MS Access), I need to somehow get the to: and cc:
values from the Outlook email into my Access database (using VBA).
Does anyone know if this can be done?
Thanks for any possible tips.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

You can use ADO object to insert data into Access table
Thanks


Vivek