Word also has a Step by Step Mail Merge Wizard (found under the Mailings tab > Start Mail Merge button), which basically walks you through the process above. Mail merge lets you easily turn one document into several personalized, unique versions of it. In addition to letters (which can be any sort of document, including certificates and coupons), you can choose emails, envelopes, labels, or directories as the document type. Let us take a small list for better understanding.Repeat this for other types of documents you'd like to use mail merge for. Here is an example of a contact list to whom we will send emails, prepared in Excel.
Open Microsoft Excel or whichever spreadsheet software you use. Merge Data from an Excel Workbook into a Word Document. The first thing I would do is create the Excel worksheet from which my Word template will pull data from. We will draft a letter in a Word document and will replace the default contact details with custom contact details.ĭon’t worry this easy tutorial can help you achieve this! Let’s say I want to create mailing labels for a save the date postcard. Make any changes to the font style or size on the labels. Select Label options to change the label size. When youre done formatting your labels, on the Mailings tab, click Preview Results. How do I mail merge labels from Excel to Word 2016 Open Word 2016. If youre just creating mailing labels, on the Mailings tab, click Address Block.
We'll outline a much more linear process - creating an address file in Excel, merging in.
Recommended Read: How to Create a Calendar in Excel? 1. These placeholders are called Mail Merge Fields, and theyre populated by the data from your Excel worksheet when you finish the merge. Learning to use Mail Merge in Microsoft Word can be a daunting task if you're trying to use Microsoft Help. To begin with, we will take an example of a sample contact list containing each person’s business address, company name, phone number, and email address, etc. Tip: If none of the options match your labels, click New Label, enter your labels information, and give it a name. So, here is the problem Im having: Lets say I only have 3 rows of data in the CSV file (3 items that need labels). Under Product number, select the product number for your labels. The actual word document (mail merge file) is formatted to return 18 labels per page (3 rows of 6) and works from the top right corner down, then middle top down, then left top down. In the Label Options dialog box, next to Label products, select the company that made your labels. You’re at the right place if this is your problem. On the Mailings tab, click Start Mail Merge > Labels. You are probably here because you have 100 or 200 people to whom you want to send out a customized but identical email with the personal details of each person on your list. So it makes it a good choice to use for a mail merge. Excel is easy to use and add names to and many people just find it easy to use. We will learn to use the mail merge tool with the help of crucial examples and supporting images. Mail merge using a list / database in Excel is very popular. Let’s learn to mail merge a contact list from Microsoft Excel to MS Word.