how to do a mail merge in excel for labels

Save the document by click File ( Office button) > Save. Click Preview Results in Preview Results group, then the labels are created.

Click Update Labels in the Write & Insert Fields group under Mailings tab. Repeat step 7 to insert all the information you need, see screenshot: Generate mailing lables from a spreadsheet of addresses for free using Google Docs, Google Sheets, and Autocrat (free add on). Tip: Use common size labels on sheets and always make sure you have a. Put the cursor at the start of the document and click Mailing > Insert Merge Field, then select the information you want to be included in the labels. Mail merge is the combining of information from a spreadsheet or database. Then delete all 《Next Record》in the document, see screenshots: If the list you need to import is in an Excel workbook, there will be a Select Table dialog popping up after you selecting the workbook and clicking Open button. In the Select Data Source, select the file and click OK. Click Mailings > Select Recipients, select the option for your needs. Then click Home > Show/Hide Editing Marks for more convenient to edit the labels. If you have any updates, please feel free and come back to share with us. After finishing merge, press CTRL + A, F9 For more details, please view the video. Please try the command, insert picture field 3. In the Label Options dialog, select North American Size from the Product number list. You have typed the link like C:\Users\jiangy\Desktop\image\2.png 2. Open a new Word document, and click Mailings > Stat Mail Merge > Labels.

How to do a mail merge in excel for labels