In the Microsoft Excel dialog box, under Named or cell range, select the cell range or worksheet that contains the data that you want to use, and then click OK. Click MS Excel Worksheets via DDE (*.xls), and then click OK.
In the Confirm Data Source dialog box, click to select the Show all check box. Start the mail merge and then select your recipients by navigating to the Excel spreadsheet that contains your data. On the Advanced tab, go to the General section.Ĭlick to select the Confirm file format conversion on open check box, and then click OK. Under the Number tab, select Special and then Zip Code. Highlight the zip code column in Excel and right click. Your data source must be the first sheet in the workbook.
:max_bytes(150000):strip_icc()/ExcelData-5bec4181c9e77c0026283623.jpg "how to do a mail merge for labels from excel")
Unfortunately, both products, by default, drop the leading zero in zip codes.įirst, ensure that your data is formatted correctly in Excel. You can use Excel to populate mailing labels in Word.
0 kommentar(er)
