Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge Problem
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? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge Problem
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...mail_merge.htm ). This may help identify or eliminate the problem. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org BoRed79 wrote: 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? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge Problem
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/boo...x#AboutTheBook Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "BoRed79" wrote in message ... 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge problem | Mailmerge | |||
Insert Merge Field problem with Word-Mail Merge from Excel documen | Microsoft Word Help | |||
Mail Merge To Doc Problem | Mailmerge | |||
Mail Merge problem | Microsoft Word Help | |||
mail merge problem | Mailmerge |