Advanced Mail Merge Example

The following example builds off of the intermediate mail merge example. Besides just replacing the 'To', and 'Subject' fields with database fields, you can also replace text in the body of your email, using the mail merge method. This time we will be sending out a fictious reciept for an invoice. In our database, we are also storing the amount of the invoice, and the date it placed. We will add that field to the body of the email. Again, to add a database field to an email, you need to surround the the field name with '##'. The mail merge method also keeps track of all the successful emails that were sent off. So you can keep a record of what emails were sent.

See the example below.