email to multiple recipients

[sue gray]

I have a report that is currently being printed that I would like to be able
to email to individual employees. The report contains each employees time
summary on a separate page for each employee. I have done some research on
this site, but am still confused. Can someone point me in the right
diretion, please.

 

[Tony Toews [MVP]]

I have a report that is currently being printed that I would like to be able
to email to individual employees. The report contains each employees time
summary on a separate page for each employee. I have done some research on
this site, but am still confused.

You will need to create a query containing the relevant records
including email addresses and fields necessary for passing to the
reports to select the appropriate records. Such as the primary key or
foreign key of the individual.

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

For a page on how to print a report for a single record and how to
generate reports to attach to emails see the Emailing reports as
attachments from Microsoft Access page at
http://www.granite.ab.ca/access/email/reportsasattachments.htm

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/

 

[FMS Development Team]

I have a report that is currently being printed that I would like to be able
toemailto individual employees.  The report contains each employees time
summary on a separate page for each employee.  I have done some research on
this site, but am still confused.  Can someone point me in the right
diretion, please.  

Hi Sue,

Check out our Total Access Emailer program.

Total Access Emailer is an Access add-in that lets you send
personalized emails to everyone in your list. From a table or query,
it can send emails to every email address and customize the message
and subject with field values from each record. I can also filter
data and reports to include that person's data in the body of the
message or attach it as a file.

In Access 2007, it can attach the Access report as a PDF file. Emails
can be in text or HTML format. You can also use the HTML output of a
report and make that the body of your message (this lets you use all
the power of Access reports to customize your entire message).

Total Access Emailer includes an interactive Wizard and a
programmatice interface for VBA developers so you can add it directly
in your code. A runtime library is available.

You can download a 30 day demo/trial version. For more info vsit
http://www.fmsinc.com/MicrosoftAccess/Email.asp

Good luck.

Luke Chung
FMS, Inc.
http://www.fmsinc.com