Word not converting Excel Data Source in mail merge

[tatiana.stephens]

Hello. Can someone help me?! I am trying to create a mail merge
document in word using an excel data source. I can open this sheet in
excel no problem. it isnt that big, its 16 columns wide by 53 rows. and
everytime i try to open it as a data source in word mail merge manager,
word goes to convert it, and then says it has insufficient memory and
cant open the source. Its soooo annoying, cause i have used way way
bigger documents as sources on way crappier computers than this one.
(it is a new ibook G4, Mac OSx 10.4) what is the problem, and why does
it even need to convert the source anyway? i thought excel and word
worked together!?!! this is driving me nuts and making me really regret
switching to mac. someone please explain how i can fix this, I have
managed to do mail merges but it seems the data source has to be so
small to make it work that there is barely any point doing a mail
merge.
thank you!

 

[Robert R. Rahl]

Hello. Can someone help me?! I am trying to create a mail merge
document in word using an excel data source. I can open this sheet in
excel no problem. it isnt that big, its 16 columns wide by 53 rows. and
everytime i try to open it as a data source in word mail merge manager,
word goes to convert it, and then says it has insufficient memory and
cant open the source. Its soooo annoying, cause i have used way way
bigger documents as sources on way crappier computers than this one.
(it is a new ibook G4, Mac OSx 10.4) what is the problem, and why does
it even need to convert the source anyway? i thought excel and word
worked together!?!! this is driving me nuts and making me really regret
switching to mac. someone please explain how i can fix this, I have
managed to do mail merges but it seems the data source has to be so
small to make it work that there is barely any point doing a mail
merge.
thank you!

Tatiana: When you are opening the Excel data source, instead of using
"Entire Worksheet" as the Cell Range try a specific range, for example
A153. This has worked for me in similar circumstances. RRR

 

[Daiya Mitchell]

Totally wild guess‹if specifying page range doesn't work:

In Excel, resave the document with a different name on your computer, and
try merging that one.

I'm suggesting this only because I ran into an oddity in File Maker Pro 5.5
where I had to resave Excel documents that had been created on a PC for FMP
to recognize them, and since you recently switched, conceivably something
similar could apply.