Mail Merge is a process to create customized emails, letters, and documents from a generic form or template. The original document contains static text with placeholders for substitutions for elements like names, addresses, emails, or other individualized or unique information. Typically the data used to populate these placeholders is held in a database, spreadsheet, or CSV file. A column in a spreadsheet could contain a list of names that correspond with a list of email addresses. These would then be populated into the template, creating a customized email per email address.

This functionality can be replicated using SendGrid’s SMTPAPI, using Substitution Tags and Custom Fields in Marketing Campaigns for marketing emails and our transactional templates application for transactional emails.