If a field you want says Not Matched, select the drop-down list for that field and then choose the column name that matches that column in your list. Check if the fields you want, appear in the list. Tip: To be sure Word finds the names and addresses in your list, choose Match Fields. To easily add an address block to your letter, envelope or label use the Address Block tool.Ĭlick where you want to add the address block in your document. Next, add merge fields to your main document (labels, envelopes, etc.). 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.
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)
