Excel Word Mail merge

[Ian Morrin]

Hi,

I am trying to merge an excel doc into a word letter I am using Mac Office
11.1.1. When I go to word and select the file that I need to use word just
hangs. I have tested it using a different less complicated spread sheet and
all seems to work fine. Is there a limit to the size of spread sheet that I
can mail merge?? In the past I have transferred the files to a PC and it has
worked fine???

Any suggestions??

Thanks

 

[Jim Gordon MVP]

Hi Ian,

Will the spreadsheet open in Excel Mac all by itself?

-Jim

 

[Ian Morrin]

Jim,

Yes the Spread sheet opens fine in excel, it was created in Mac excel and
works fine. Below is what I wrote in the Word newsgroup.... My Mac also has
some remnants of OS9 on it fonts etc.. Not sure if there may be a conflict
there or not????

I have a spreadsheet that has data, Names, Dates, Values etc.. I then have a
generic letter in word that I need to insert this data into. I use Data
Merge Manager select Form lettter, Then Get Data - point the merge manager
to the spreadsheet location. I then select the sheet that I require ( there
are about 6 sheets in total. It is at this point that word 'hangs' and I get
the spinning circle. I have left this for about 45mins with no results then
I have to Force Quit Word....

 

[Jim Gordon MVP]

Hi Ian,

Thanks for responding with good detail.

There are a lot of things I can suggest here, but I have another question:

Can you perform a mail merge with a different workbook? If this workbook
is persnickety, perhaps you can copy the data to another workbook (copy

paste special > values_

=Jim

 

[Ian Morrin]

Jim,

I have just tried the Paste Values into a new workbook and no joy
unfortunately. Having seen all the problems people have been having with
font conflicts I have moved any fonts out of fontbook that are conflicting
just in case and re-started the machine.. Still no joy?? The daft think is
that if I transfer the docs to a PC it all works fine no dramas at all...

Ian