Either way, reviewing these steps is good practice for making sure you are efficient with your time and don’t cause yourself any grief when it’s time to create labels.
#How to do a mail merge in word for labels how to
Once every field is added, click on Close. If you already know how to mail merge labels from Excel to Word 2010, then the below instructions for later versions are very similar (with just with a few minor changes). For example, here we will need to click on First Name and then click Insert, then click on Last Name and then Insert, and so on. Click on each field and then click on Insert one at a time. This is where you will choose which of your columns are merged and in what order. Then at the bottom click on Next:Arrange your labels.Ĭlick on More Items and it should open a new window for Insert Merge Field. Scroll through the options to make sure the data is correct and click on OK. Now you should be able to view your Mail Merge Recipients. Once you find and open your database file a window will appear asking to select a table. Then click on Next:Select Recipients.Ĭhoose the option to use an existing list and click on Browse. Then click on your product number and click on OK.
![how to do a mail merge in word for labels how to do a mail merge in word for labels](https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/31230925/mailmerge2.png)
For more info, see Set up a mail merge list with Word.In Microsoft® Word click on the Mailings tab at the top of the screen. Word data file is a data source you can create on the fly, within Word. See Use Outlook contacts as a data source for a mail merge Mail Merge for Microsoft Word and Office 365 is the program to write a single document (e.g.: a letter to your customers). Outlook Contact List contains data in a format that can be read by Word. For more info, see Prepare your data source in Excel for a mail merge in Word for Mac. Excel spreadsheets and Outlook contact lists are the most common data sources, but if you don't yet have a data source, you can type it up in Word, as part of the mail merge process.Įxcel spreadsheet works well as a data source if all data is on one sheet and the data is formatted so that it can be read by Word. Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information.
![how to do a mail merge in word for labels how to do a mail merge in word for labels](https://mediawiki.middlebury.edu/LIS/images/3/37/Word_2003_label_options.jpg)
This type of document is also called a catalog merge.Ĭreate a directory of names, addresses, and other information
![how to do a mail merge in word for labels how to do a mail merge in word for labels](https://i.ytimg.com/vi/eMZLC30bDDo/maxresdefault.jpg)
Use it to print out your contact list, or to list groups of information, like all of the students in each class. You'll be sending the email directly from Word.Įnvelopes or Labels where names and addresses come from your data source.Ĭreate and print a batch of envelopes for mailingĬreate and print sheets of mailing labelsĭirectory that lists a batch of information for each item in your data source. Each letter prints on a separate sheet of paper.Ĭreate and print a batch of personalized lettersĮmail where each recipient's address is the only address on the To line. Letters that include a personalized greeting. Follow the links for details about each type: Word provides tools for incorporating your data into the following kinds of documents. Use Outlook contacts as a data source for a mail merge
![how to do a mail merge in word for labels how to do a mail merge in word for labels](https://i.ytimg.com/vi/K2JEkRamSEU/maxresdefault.jpg)
If you know you'll be using Excel or Outlook as the source of your data, see: If you don't yet have a data source, you can even type it up in Word, as part of the mail merge process.įor details about data sources, see Data sources you can use for a mail merge. Excel spreadsheets and Outlook contact lists are the most common data sources, but any database that you can connect to Word will work.