Here, your letter is the template file - it has placeholders for your contacts’ names and addresses. įor example, let’s say you want to perform a mail merge to create mass letters. Each cell in the data file contains different information (first name, last name, email address, etc.) that will be placed in your template file in the corresponding space.Įssentially, a mail merge automatically adds the personalization data from your data file to your template file. Data File : a data source like a Microsoft Excel spreadsheet or a Google Sheets file.And that data (names, addresses, etc.) is fetched from a data file. It specifies the places where the personalization data will go. Template File : the document that holds the message you’ll be sending out (like a letter or an email).How Does Mail Merge Work?įirst, you need to understand the two essential components of every mail merge. Let’s now explore how a mail merge works. Instead of typing a letter for each recipient, you can use a form letter to make quick, unique, personalized letters for each person.Įssentially, if there’s a document you need to personalize at scale, mail merges can take care of it for you! Note: A form letter is a template file used to create mass letters. You can use mail merges to create personalized messages automatically for: This spares you the trouble of manually personalizing each document yourself! What Are Mail Merges?Ī mail merge lets you create personalized documents that are automatically customized on a recipient-by-recipient basis.
How to Use Mail Merge to Send Bulk Letters.
(Click on links to jump to specific sections) Later, I’ll mention two issues of using the traditional method for mail merges and suggest a better and more powerful alternative to help you send mass emails.Īdditionally, I’ll also answer seven FAQs associated with mail merges. Then, I’ll go over how to mail merge using an Excel spreadsheet and a Word document. In this article, I’ll first cover what a mail merge is and explain how it works. It works by automatically adding personalization data from a data file (for example, a spreadsheet) to a template file (like a letter or an email). These are the type of people we are trying to connect with.Īll of this research must be added to a spreadsheet we have already prepared on Google Sheets.A mail merge is a handy way to send personalized mass letters and bulk emails quickly. You can see in her bio that she is "responsible for sourcing many clients for Fiore Legal." This means that this individual is involved in the decision-making process regarding which clients remain with Fiore Legal, and which clients are referred to other law firms. It will be the chosen candidate’s responsibility to either call or review the website of each law firm to make these determinations.Īttached is an example of what the appropriate individual might look like. Specifically, for each law firm, we need the gift boxes addressed to case managers or other individuals who are responsible for signing up or rejecting case leads within the firm. The chosen candidate must determine and verify the mailing addresses for each of the 100 recipients and must research who within each law firm is the most appropriate individual to address the gift boxes too. We currently have a list of 100 law firms we would like to send these gift boxes too. The campaign involves mailing promotional gift boxes to law firms who fit our target demographic. We are preparing to launch a marketing campaign for our startup.