Failure to have column headings will show up See notes on zip codes if you are having a problem with zip codes in Excel.Ĭolumn headings are required in row 1 in Excel for field identification in Mail Merge.
If you are using XL2000, move the tab for the sheet to the far left and create a name for the data: They only go up to AutoMergeField4 so failure to provide headings will limit In Word as AutoMergeField, AutoMergeField1, AutoMergeField2 etc. select A1:G50 then supply a name (ziplabels) in the name box to left of formula bar. Actually the named range works better anyway in all versions of Excel.īut could not simply select a sheet in XL2000 as I could in XL95. Named Ranges are known and available to the entire workbook.
0 kommentar(er)
