I have set up my data in Excel using several worksheets. When I open my Word
document it asks me to "open document in workbook" so I select the specific
worksheet that contains my data, and then I select "entire worksheet" for the
"name or cell range". I have tried it both with and without the "Format for
Mail Merge box checked" with no results.
No matter how I map to the excel data the merge will not complete
successfully.
any help? I know it has found the data because it let me insert the fields
from the header row in Excel into the Word document.
Microsoft Word 2000 and Microsoft Excel 2000
Thanks
ALF2020