access to outlook

[Richard]

Hi

Are we able to set up a distribution list in Outlook and append emails to it
through VBA from Access?

Thanks in advance
Richard

 

[Arvin Meyer]

Yes, have a look at the sample code at:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Richard]

Hi Arvin

Thanks for the reply.

The code you refered to is sending email through code. I was thinking of
setting a distribution list and appending email addresses to it.

Thanks again
Richard

 

[Pieter Wijnen]

Then you have to Check out the Outlook Object model to figure it out...
(or post to an outlook news group)

Pieter

 

[Cheryl Fischer]

Here is a link to a posting from last month from ScottE with code which
appears to do what you want.

http://tinyurl.com/3almy

 

[Richard]

Thanks Cheryl

Will try it out

Richard

Here is a link to a posting from last month from ScottE with code which
appears to do what you want.

http://tinyurl.com/3almy