Automate Email Distribution List

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 ; ... 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.

Re: Automate Email Distribution List

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" wrote in message
news:ded0f461-7303-46c3-a78d-288017e8ab3c@l1g2000hsa.googleg roups.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 ; ... 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.

Re: Automate Email Distribution List

On Dec 28, 5:32 pm, chiinook wrote:
> 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 ; ... 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_E-Mail_With_Outlook_Expr ess.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.

Re: Automate Email Distribution List

lyle wrote:

>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/