Merge Excel file into Word Document


Joined
Sep 17, 2019
Messages
3
Reaction score
0
I have an excel file that is 75 lines (records) long. When I merge the excel file into a Word document only 70 lines (records) merge. The last 5 files (the Last Names begin with W) are omitted. If I reverse the alphabetical order and merge the excel file into a Word document the last 5 files (the Last Names begin with A) are omitted. Is there a limit on the number of excel files which can be merged with Excel?
 
Ad

Advertisements

macropod

Microsoft MVP
Joined
Mar 2, 2012
Messages
465
Reaction score
40
There is no such limit. It appears you've configured the mailmerge incorrectly, perhaps by specifying a named range that doesn't span the entire data set.
 
Joined
Sep 17, 2019
Messages
3
Reaction score
0
How would I find if I specified a named range and how would I correct it?
 
Ad

Advertisements

Joined
Sep 17, 2019
Messages
3
Reaction score
0
I think I figured it out. I don't understand why, but at least I know what to do in the future. Thank you for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top