Including database field references

In both system e-mail and e-mail that you compose and send, you can personalize messages by including references to specific fields in the database, in the form {tablename.fieldname}. When the message is sent, Manager will replace the reference with the actual data from the named field.

For example, your Email Welcome template might contain the text:


If you have any questions, please contact us directly at {MERCHANT.EMAILADDRESS}, or call {MERCHANT.PHONE}.<br />
Welcome to {MERCHANT.NAME}. We look forward to working with you for many years to come!

When you send the message, the text will read:

If you have any questions, please contact us directly at info.AcmeWines.com, or call 800-555-9876.

Welcome to Acme Wines. We look forward to working with you for many years to come!

For a list of the fields you can include from each database table, click a table name below.


Customer

Customer Selection

Inventory Location

Merchant

Payment Info


Person

Report Variable

Transaction

Transaction Item

User Profile


In addition to the fields from specific database tables, you can also include the system-wide fields {CURRENT_DATE} and {CURRENT_TIME}.


Related topics:

Sending a one-time e-mail

Compose and send: plain-text e-mail

Compose and send: formatted e-mail

Including database field references

Using the image library

Sending the mail