Tagging a Microsoft Access Report
Microsoft Access® reports are data-driven documents. A data-driven document
is one in which you insert placeholders where you want information from the fields in your
database to appear within the report. If your database has a field containing
e-mail addresses, you can send different sections of a report to selected e-mail
addresses. For example, if you are sending invoices, you might insert the
e-mail address of your clients' account payable contact into the invoice page header
so that each invoice is sent to the correct client contact person. All of
the pages associated with the same e-mail address will be combined into a single
PDF file. The easiest way to insert a PDF-eXPLODE tag into an Access report is using a
Insert a PDF-eXPLODE Tag
Click the Text Box tool
in the toolbox.
- Click the upper left corner of the page header section to indicate where
you want to place the text box.
Place the insertion point in the text box and type an expression that
includes the e-mail address or the name of the field containing the e-mail
address, and an optional Message ID Tag. For example, if
your database has a field named Email, you would enter the following
="<pdfexplode>" + [Email] + "</pdfexplode>"
If you are using a Message ID Tag, for
example invoice, then your tag would look as follows:
="<pdfexplode>invoice#" + [Email] + "</pdfexplode>"
- Make the text field as wide as necessary for the entire PDF-eXPLODE tag
to appear in its entirety for the longest e-mail address. Click and drag the
right handle of the text field all the way to the right margin.
- A tag must fit entirely on a single line. Apply a small font size
to minimize the risk of a tag not fitting entirely on a single line.
the text box, click Properties and click the Format tab. Enter
6 for the Font Size.
- The entire tag must have a standard Windows font applied to it, such as Arial
or Times New Roman.
the text box, click Properties and click the Format tab.
- You may change the color of the tag to white to make it invisible in the
resulting document. Right-click
the text box, click Properties and click the Format tab. Set