Use If macro with combined records
AY Mail 2. Professional and Corporate Editions
Data managing skills required.
When you merge your data into combined records
you can use the if macro to compose your message.
For example, you imported data about magazine subscriptions:
Depending on the number of imported records for the particular
email address, one, two or more fields will be filled during the
import process. In the above example, Kate had two records, so
Subscription1 and Subscription2 are set while
Subscription3, Subscription4, and Subscription5
When composing the message, you want to display the information
about the subscriptions with data filled in (Subscription1
and Subscription2) and skip the information about the rest
(Subscription3, Subscription4, and Subscription5).
You can do this with if macros:
Here you can see the table with five data row, and each row
represents one subscripton. The cells of this table are filled
with the text macros, which will insert publication name
and expiration date into the table.
This example assumes that Subscription1 is always set, so
the first row of the table is always included. The other rows are
removed if the corresponding Subscription field is unknown.
As a result, the recipient will only see the rows for the fields
Kate will receive the following message:
You can see that the table contains only two data rows because
there were two records for Kate. The other three rows were excluded
with the if macros.