Mail merge Word Excel

[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

Ian

 

[Daiya Mitchell]

Are you trying to merge an actual piece of a spreadsheet, or using the
spreadsheet to pull the data from?

When you say "merge," are you actually using Tools| Data Merge Manager?

I can't quite picture what you are doing, so can't figure out the problem,
but I do know that if you want an embedded excel spreadsheet in the word
doc, it can't be bigger than a page.

 

[Ian Morrin]

Hi,

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....

Ian

 

[Daiya Mitchell]

I don't have a clue. Just to check, perhaps do a save as, delete the sheets
you aren't merging from, and see if it works with a single-sheet source
file?

DM