Mail Merge and Personalization

What is Personalization?

Personalization is a powerful way to give each email you send out a personal touch. Instead of addressing an email to sad123@hotmail.com it can be addressed to Sadie Birch. Plus, NetMailBot can change the body of a message for each and every recipient on your mailing list.

 

What can be Personalized?

There are three parts of an email that can be personalized
  1. From address
    Each email can be addressed to a "friendly name" instead of the email address. For example, (screenshot 1) is addressed to John Doe instead of jdoe@exclamationsoft.com (screenshot 2).
  2. Message Body
    The body of the message can be altered and personalized for each recipient. For example, the body in (screenshot 1) starts off with "Dear John Doe," instead of the impersonalized "Dear Sir," in (screenshot 2).
  3. Subject
    The subject of the message can be altered and personalized for each recipient. For example, the body in (screenshot 1) starts off with "Dear John Doe," instead of the impersonalized "Dear Sir," in (screenshot 2).

 

Parameters to use...

The following parameters are needed for mail merge and personalization:
  • -dbtable
    • This parameter specifies the database table where email addresses are stored.
  • -dbemailcolumn
    • This parameter specifies the column name that contains email addresses.
  • -dbreplacementids
    • Replacement identifiers are tags used for subsititution. There are two parts to a replacement id: A replacement tag and an database column name. For example, consider the replacement id "<<first_name>>=clientFirstName". The tag "<<first_name>>" is placed in an email body such as "Dear <<first_name>>, thank you..." and will be replaced by the value of clientFirstName.
  • -dbuseaddressee
    • This parameter specifies the addressee to use, "to", "cc", or "bcc".
  • -dsn
    • This parameter specifies the dsn (data source name) to use for the database
  • -personalize
    • Simply specifying this paramter will cause NetMailBot to do the replacements as specified by the replacement identifiers.

Example

Click Here to view a complete working example using Mail Merge with an Access Database

Click Here to view a complete working example using Mail Merge with a CSV (Text) file