E-mail report to addresses in field of underlying table

[SDMaryanne]

I have a report that prints out when maintenance is due for different
people's vehicles in our company. One of the fields in the customer table is
the email address. I want to be able to click a button to email the report
to all the people who have maintenance due - approximately 30 - 40 people
each month, rather than exporting the report and emailing separately, which
involves entering email addresses for all those people. Is there a way to do
this?

 

[Tony Toews [MVP]]

I have a report that prints out when maintenance is due for different
people's vehicles in our company. One of the fields in the customer table is
the email address. I want to be able to click a button to email the report
to all the people who have maintenance due - approximately 30 - 40 people
each month, rather than exporting the report and emailing separately, which
involves entering email addresses for all those people. Is there a way to do
this?

But do you want to email a report or just a notice?

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

You will need to use VBA code to run through a recordset see
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

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/

 

[SDMaryanne]

Thanks Tony,
My report includes vehicle id, description & year, plus name & phone of the
POC. I want a notice to go out when I click a button. The notice needs to
be something like: John Doe, your Ford truck, vehicle 04-21942 is due for
maintenance.
In other words, an individual record from the report would go to each person.
I'll give the recordset a try and let you know how it goes.