Email To A Group

[Arturo]

(Access 2003) I need to know how to accomplish the following. I need to send
a PDF file to a group of people from an Access list (either a table or a
query), or export a list that will allow me to do the same thing in
Groupwise. Let me clarify my request.

Option #1 – Create the email from Access, send the email with a macro using
the “Send Object†method, and attach the PDF file. How would I send it to
everyone on the list at one time?

Option #2 – Export a list that can be accessed in Groupwise. Then, send the
PDF file to all recipients on the list at one time.

The goal is to send one email to several people at one time without having
to select each person individually.

Thank you for your help.

 

[Mark Andrews]

You can just build a string that represents the list of emails you are
sending the email to and send one email or loop through a recordset
and send the same email multiple times one to each person. Either way I
think you need to do a little VBA code to loop through the recordset and
build the string..

Perhaps some of the articles on the access web would help:
http://www.mvps.org/access/modules/mdl0059.htm

If you want to get advanced and send customized emails to each individual in
your list see:
http://www.rptsoftware.com/products/email/

Creating the pdf file can be done differently depending on which version of
Access you are using Access2007 has some pdf capabilities built-in for older
versions most people use stephen lebans code to create a pdf or use a third
party pdf print driver such as win2pdf.

HTH,
Mark

 

[GBA]

cheap & dirty + semi manual is option 2. If you have your query that makes
your list of email addresses - have you attempted to simply copy it and paste
into the groupware TO or BCC field??

potentially you might have to export that query to txt first; and then do
the copy/paste...

 

[Tony Toews [MVP]]

(Access 2003) I need to know how to accomplish the following. I need to send
a PDF file to a group of people from an Access list (either a table or a
query), or export a list that will allow me to do the same thing in
Groupwise. Let me clarify my request.

Option #1 – Create the email from Access, send the email with a macro using
the “Send Object” method, and attach the PDF file. How would I send it to
everyone on the list at one time?

These solutions mean using some VBA code.

See the Sample Code illustrating looping through a DAO recordset page
at the Access Email FAQ at
http://www.granite.ab.ca/access/email/recordsetloop.htm

Option #2 – Export a list that can be accessed in Groupwise. Then, send the
PDF file to all recipients on the list at one time.

Microsoft Access Email FAQ - Novell GroupWise
http://www.granite.ab.ca/access/email/novellgroupwise.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/