
Your mail merge data source can be other file types, but a.

In the “Specify Field Order for Export” dialog, chose the fields you want to be able to merge in your template file and click export.Click “File” > “Export Records,” change the file type to “Merge,” and choose where you want to save your file.In your FileMaker system, get into the found set of records you would like to merge with your template.In order to prepare your FileMaker records for mail merging, you need to export them as a. If you do not have Microsoft Word, there are plenty of other free word processors out there that are able to perform mail merges. In this example, we will be using Microsoft Word to create a template, and FileMaker as the data source. Select the table SerialNumbers and the field IP Address.To create a mail merge, you need two things: a template and a data source.

While editing the a layout displaying data from the DiagnosticReports table, drag a new field onto the layout.To do B, show only the current IP Address for this Serial Number: Set the IP Address field to Auto-Enter the Looked-Up value from the SerialNumbers table for the IP Address field.Go to the Fields tab of the Manage Database window.To do A, store the IP Address at the time the Diagnostic Report is made: Do you want A: To store the IP Address at the time of the Diagnostic Report or to B: Show only the current IP Address for this Serial Number.

In the Relationships tab of the Manage Database window (File Menu > Manage > Database > Relationships Tab) you will need to draw a line from the "Serial Number" field of the SerialNumber table to the "Serial Number" field of the DiagnosticReports table SerialNumbers::Serial Number >-< DiagnosticReports::Serial Numberįrom here you have a choice to make.

This is not necessary if you always want to show the current IP Address for this serial number.)
