Emailing Microsoft Access Reports and Data
Microsoft Access lets you create all kinds of great reports
combining data from multiple tables, and letting you sort,
aggregate, and format it in a variety of ways. With the use of
sub-reports, you can easily display data in multiple sections to
illustrate one-to-many relationships and linked data.
However, emailing Access reports to your contacts is more
challenging. Fortunately, Total Access Emailer gives you many ways
to leverage your existing Access reports so that you can disseminate
your data to all your contacts.
Sending
Personalized Emails with Data from Access
Assuming you have a list contacts with email addresses in a
table, Total Access Emailer lets you easily create a personalized
email for everyone in your list. The message can be text or HTML and
can include references to fields in your data source. That lets you
easily customize messages to include things like "Dear [FirstName]
[LastName]..."
You can also include an attachment in formats
such as text or Excel with data from a table or
query. The data can be the entire list or
filtered by values in your data source. This
makes it easy to limit the data by an ID value
and only email personal information to each
contact.
Several
Ways to Email Microsoft Access Reports
Because Total Access Emailer runs within Microsoft Access, it
gives you the full power of Access including its reports. Easily
personalize your messages with Access reports in a variety of ways
depending on your needs:
-
As
an attachment in Adobe PDF, text, HTML, Excel, rich text
(RTF), report snapshot (SNP), or XPS formats
(PDF and XPS are only available in Access 2007)
- As the HTML body of your message
- As the text body of your message
Email Microsoft Access Reports as Attachments to Everyone
For any report, you can simply have Total Access Emailer export
the report to a format you specify such as Adobe PDF, text,
Snapshot, HTML, RTF, or XPS. It is attached to your email message
and everyone on your list gets the same report or reports.
Email a Different Report as an Attachment to
Each Person
More useful is filtering a report to only send the appropriate
data to each recipient. Total Access Emailer can automatically limit
your report by the filter field or fields you specify. This lets you
send each recipient information private to them. No one else sees
those pages.
Examples of this would be taking your existing
Invoice report, and emailing late invoices to
everyone on your list. Simply create a query
that defines who should get late invoices and
off they go.
Imagine how easy it is and all the paper you save by distributing
your reports this way!
Example of Attaching the Invoice report as a PDF file filtered by
CustomerID
Use an Access Report for Your
HTML Message
For more advanced and customized use of Access reports, you can
use its HTML output feature as your message itself!
Microsoft
Access lets you export reports to HTML format.
This powerful feature lets you leverage the
power of the MS Access report generator to
create very complex and sophisticated reports in
HTML.
Total Access Emailer takes advantage of
this feature so you can use Access reports as
the designer of your HTML messages. Simply
create an Access report with the message you
want to send to each recipient, place your
fields, format them, aggregate your data, etc.
You can export it to HTML to verify it's
designed exactly the way you want. Once you're
satisfied, have Total Access Emailer generate
the HTML output for you.
Without a filter,
everyone gets the same message. By filtering the
report from your data source with the email
addresses, Total Access Emailer sends each
recipient their own information.
Example of the Invoice report filtered by CustomerID as the HTML
message
Use an Access Report for Your Text Message
Similarly, Microsoft Access can export reports to Text format.
This is sometimes better for displaying columnar data in an email.
Simply specify the report for the text message, and Total Access
Emailer sends them out.
