I'm having an odd problem merging an excel document into a word document.
There are 3 sheets, all formatted the same way. I can merge Sheet1 just fine.
Sheet2 & Sheet3 are giving me fits though. I try to do the mail merge the
same way as I do with sheet1 and first, instead of just bringing up the
contents it brings up a 'select table' box. I then have click on options and
check the system tables box before anything shows up, then it shows sheet1,
sheet2, & sheet3 again. If I click on sheet2 or sheet3 again and ask it to
open it, I get an error message - "Word was unable to open the data source."
What is causing this and how can fix this?