It may help somebody to know that it only appears possible to use an Excel Spreadsheet as a Mail Merge data source from WORKSHEET "Sheet1" of the spreadsheet, "Sheet2", 3. 4 etc do not work and a RENAMED workshee (eg "List1") does not work either even if it is the first worksheet.
Not knowing this gem of unintuitive software can waste one a significant amount of time.
Does anybody know of any other nasties like this when merging.
Try saving the file and closing it , then open the Word document using Method 2 (DDE Link) - I assume you`ve ticked the option in Word Options to "Confirm File conversion on Open" under the General Tab.
By the way, Don`t "Hide" any columns or "Group" them and hide them - Even I can`t get that to work!
I am wondering if this a version issue. My memory is that it worked fine with any worksheet name in 97 and I think 2000 but I'm using 2003 and MS changed the interface quite a bit with the 2000 - 2003 upgrade.
Which is, I presume, the same option? I DO NOT have this ticked and, as I say, it works for me. Perhaps there is more to it than having this option ticked, and doing so has made it work for you for some "indirect" reason?