Automate Email Distribution List

[chiinook]

I have built a fairly simple database to manage contact information
for about 300 clients. Some of these have requested that I send them
our publications by email rather than post. I have created a query
which culls the names and addresses of these contacts. Then I export
the result to a .csv file and edit it into a distribution list
format ... (ie FirstName LastName <[e-mail]>; ... etc.)

Is there a way for me to automate this same process placing the entire
list in the to: portion of an outgoing message sent via gmail?

I have no experience with VBA so please be gentle.

[Phil Stanton]

If it is any help, I have a Db which will look at your Db and create an
outlook folder and distribution list

Phil

"chiinook" <ma***************@gmail.comwrote in message
news:de**********************************@l1g2000h sa.googlegroups.com...

>I have built a fairly simple database to manage contact information
for about 300 clients. Some of these have requested that I send them
our publications by email rather than post. I have created a query
which culls the names and addresses of these contacts. Then I export
the result to a .csv file and edit it into a distribution list
format ... (ie FirstName LastName <[e-mail]>; ... etc.)

Is there a way for me to automate this same process placing the entire
list in the to: portion of an outgoing message sent via gmail?

I have no experience with VBA so please be gentle.

[lyle]

On Dec 28, 5:32 pm, chiinook <[e-mail]:

I have built a fairly simple database to manage contact information
for about 300 clients. Some of these have requested that I send them
our publications by email rather than post. I have created a query
which culls the names and addresses of these contacts. Then I export
the result to a .csv file and edit it into a distribution list
format ... (ie FirstName LastName <[e-mail]>; ... etc.)

Is there a way for me to automate this same process placing the entire
list in the to: portion of an outgoing message sent via gmail?

I have no experience with VBA so please be gentle.

GMail is (now) pop-able and smtp-able. So you can just use your GMail
account in your e-mail client like any other account. As you don't
know VBA I recommend you open the text file you describe in Notebook,
copy its contents and paste them into the outgoing address of your
message.
If you want to mess with VBA you can find a CDO example at
http://www.ffdba.com/downloads/Send_E-Mail_With_CDO.htm
and an Oulook Express example at
http://www.ffdba.com/downloads/Send_...ok_Express.htm
I recommend that the Outlook Express procedure be ignored when
planning serious work, but for a VBA neophyte, who knows?
There are plenty of other examples of e-mail sending code about
including (shudder!!!!) Outlook automation (shudder!!!!). You can find
them with a Google search.

[Tony Toews [MVP]]

lyle <ly************@gmail.comwrote:

>There are plenty of other examples of e-mail sending code about
including (shudder!!!!) Outlook automation (shudder!!!!). You can find
them with a Google search.

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/