Mail Merge Problem

[BoRed79]

I am trying to do a mail merge from an Excel data source.

The mail merge appears to complete sucessfully, but when I look through the
merged data the last 100 or so records appear to be missing.

I have gone back and started again and noticed that in the bit where I
select the data source, it is not picking up the last 100 or so rows in the
list - thus explaining why they are not being merged.

I am at a loss, however, to discover how to get the information into word -
as nothing seems to make a difference.

Any ideas?

 

[Graham Mayor]

Clearly there is something wrong with the record at the point where the
merge stops, but without access to the data it is hard to suggest what the
problem might be. One thing you can try is to export the data to a CSV
(comma delimited text) format, open that in Word and convert to a table (see
http://www.gmayor.com/convert_labels_into_mail_merge.htm ). This may help
identify or eliminate the problem.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Beth Melton]

Did you check your datasource and verify there aren't any empty rows at the
break? Note that it might be hidden so check for that too. Otherwise, are
you using a Named range or the entire worksheet when you select your
datasource for the merge? If you are using a Named range then it sounds like
the Named range needs to be modified.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/