How to Mail Merge FM11 and SMTit Pro -
08-08-2010
, 02:00 PM
Hello
I do have a database of FileMaker Pro 11
Advanced with two tables, "Table 1" with
fields with info about customers and
"Table 2" with fields related with mail
settings for the plugin SMTPit Pro.
I am using three layouts: "Layout 1"
mail settings (authentication, mails
server, password etc), "Layout 2" mail
(to, from, body etc) and "Layout 3" with
information about customers and products.
In "Layout 3" I do have a block of text
(not a field) whith merged text (using
merged fields) that uses information of
"Table 1" (customers) and works
perfectly and changes when changes the
content of customer field.
I do want to send individual mails to
each customer using SMTPit Pro from
"Layout 2" and include in the body field
of the mail the text corresponding to
each customer of "Layout 3" (info from
Table 1).
The setting of the mail it is OK and I
can send mails from "Layout 2". The
problem it is how to put in ("Layout 2")
the body field of "Layout 3" the mail
the merged text that changes with each
customer.
How can I do ?.
Gaston |