Be sure this information is on Sheet 1 of your spreadsheet. Make sure your data is arranged in columns on your spreadsheet (one column for names, one for addresses, etc.).
Postal code data is correctly formatted in the spreadsheet so that Word can properly read the values. You can easily import data from a spreadsheet to create address labels, name badges, inventory labels and more. Make sure:Ĭolumn names in your spreadsheet match the field names you want to insert in your labels.Īll data to be merged is present in the first sheet of your spreadsheet. Here are some tips to prepare your data for a mail merge. To create and print the mailing labels, you must first prepare the worksheet data in Excel, and then use Word to configure, organize, review, and print the mailing labels. The mail merge process creates a sheet of mailing labels that you can print, and each label on the sheet contains an address from the list.
If you want to send a mass mailing to an address list that you maintain in a Microsoft Excel spreadsheet, you can use a Microsoft Word mail merge. Get printing! If you are unsure about the process, or if you’re worried you might have made an error, try test printing the first page or two, just to double check that everything will print as you want it to.Excel for Microsoft 365 Excel for the web Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 More. For example, if you are creating address labels, you can select “Address Block”, and then match up the fields that need to be on the label with the column in your spreadsheet that has this information.ĭouble check that everything is as it should be! Select the product you are using: Start Microsoft Excel Once you have done that you will see your data file in the list. This is where you set out what information should be taken from your spreadsheet and how it should be laid out. Select “Use an existing list”, then browse to find where your spreadsheet is saved. Click on Labels and then click on Next:Starting document. Click Start Mail Merge, then Step by Step Mail Merge Wizard. In Microsoft Word click on the Mailings tab at the top of the screen. This is where you link in your Excel spreadsheet. Be sure this information is on Sheet 1 of your spreadsheet.
For this you can either use a template that you have created yourself OR you can download (and save) one of our templates which are available on our website.
5 Repeat until you have entered all the labels & codes for this question, then click OK. Select the correct option under “Label vendors” (e.g. 3 Click on the little grey square (with dots in it) on the right.