![how to do mail merge in word for labels how to do mail merge in word for labels](https://lh3.googleusercontent.com/-KP6l0DtzgSw/YZHUKyFRQxI/AAAAAAAATSQ/yqxBXhBR8gMQMs8b1LCiU5HHjmch92ZzQCEwYBhgLKtMDABHVOhxbJnhIqJP4jzjIWLMrnl7QBKGTw1b96TCsrSUcbf3DbyB7futpU1bI-cu7nrG_giV34r4PhiZF9C5DLYy3b9UG64e3MH8G4HuUjvOKUhb4td2E1YBlsu7tiwrMe_DS_8-_oZb4c9J7w5nPuamn0uxx8fT-fxDHkqul11QOMlud93xCjDkz8y1v6U-hWvPabeaXsOYXfWy_l1bq1EmkjpBuYWThceW_j3hRdq_H0OU8Q2VCdFktk9xfiDXwZrn1dv0Y3mtkGlh_S9bX8riDiD6ZB5rsQ6DtZKVphaNq4TvFvq0L_v7uD6iUnhXDu6zMs-xTs-9WoSqEb_VFm2joIGyK9msdb3DGw1_5ibt4WHRkoXEjmqcno2NUuxg8oeg8c3Jc6dIjTvHgWSDWXW373PWMMgYgx_M2SAirprA-stxMZmqNYC6GsumyvNASYajAfA_PXXv6ClwPYm5SoXgqIF80--xSY7kHKz9_yaHExBsOpaZ-hxDr378mgtyem1wJPxfxakeYxrAYpFhrYNKtYAiIllxrjy-pKqUF24xEYmpZH5zjjf2Wlhd0YCWJI6XmQLwGcELfQnhKSq1WNZPRlvw70IokAEmVTqMHMlrd4zgwidTHjAY/s0/g23l1W2H_l8iT6px1515E86owC8.jpeg)
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. In my case I am going to use Avery US Letter. Now its time for you to select the Label Vendor. Next, click on the Start Mail Merge button and select Labels. In the Columns dialog, click the preset button for Two, then change the spacing between the columns to 0.2'. On the Page Layout tab, in the Page Setup group, click Columns, then More Columns. Select the right column and Cut (Ctrl+X).
![how to do mail merge in word for labels how to do mail merge in word for labels](https://ifonlyidknownthat.files.wordpress.com/2013/03/031913_2307_microsoftwo1.png)
Now open up Microsoft Word 2007 and click on the Merge tab. Select the narrow center column (between the labels), right-click, and choose Delete Columns. Once you find and open your database file a window will appear asking to select a table. Before you start make sure you have your Excel spreadsheet ready. 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 mail merge in word for labels how to do mail merge in word for labels](https://i.pinimg.com/736x/16/6c/5a/166c5a09e58f72c88223b4b6afd51fff.jpg)
Excel spreadsheets and Outlook contact lists are the most common data sources, but any database that you can connect to Word will work.