Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge Labels (Word 2007) from Excel (2007)
I've created a mailing list using Excel. I need create mailing labels (Avery
8160) I've only been able to merge the first 60 records. There are about 10 additional records that didn't get merged. What might I have done incorrectly? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge Labels (Word 2007) from Excel (2007)
It might be worth copying the table to Word and using the word document as a
data source. While Word will merge from quite a variety of data sources, it is happiest when that source is a Word document. My guess is that you have a character in the 61st record that the merge sees as unacceptable - maybe a comma? See also http://www.gmayor.com/merge_labels_with_word_2007.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org aedcone wrote: I've created a mailing list using Excel. I need create mailing labels (Avery 8160) I've only been able to merge the first 60 records. There are about 10 additional records that didn't get merged. What might I have done incorrectly? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge Labels (Word 2007) from Excel (2007)
I've checked... and I don't see any odd characters. I do have a column that
includes email addies, but that is not included in the merge. I did check out your link prior to my original post... However, going through the archives, I did see that someone else had a similiar problem... and the following was suggested: "I have had this problem too. I found that using the field "next record" is the problem. Try it without using this field." I don't see how this would help... because how would it know what the next block to merge. "Graham Mayor" wrote: It might be worth copying the table to Word and using the word document as a data source. While Word will merge from quite a variety of data sources, it is happiest when that source is a Word document. My guess is that you have a character in the 61st record that the merge sees as unacceptable - maybe a comma? See also http://www.gmayor.com/merge_labels_with_word_2007.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org aedcone wrote: I've created a mailing list using Excel. I need create mailing labels (Avery 8160) I've only been able to merge the first 60 records. There are about 10 additional records that didn't get merged. What might I have done incorrectly? |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge Labels (Word 2007) from Excel (2007)
Next Record is essential in a label merge in all labels except the first.
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org aedcone wrote: I've checked... and I don't see any odd characters. I do have a column that includes email addies, but that is not included in the merge. I did check out your link prior to my original post... However, going through the archives, I did see that someone else had a similiar problem... and the following was suggested: "I have had this problem too. I found that using the field "next record" is the problem. Try it without using this field." I don't see how this would help... because how would it know what the next block to merge. "Graham Mayor" wrote: It might be worth copying the table to Word and using the word document as a data source. While Word will merge from quite a variety of data sources, it is happiest when that source is a Word document. My guess is that you have a character in the 61st record that the merge sees as unacceptable - maybe a comma? See also http://www.gmayor.com/merge_labels_with_word_2007.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org aedcone wrote: I've created a mailing list using Excel. I need create mailing labels (Avery 8160) I've only been able to merge the first 60 records. There are about 10 additional records that didn't get merged. What might I have done incorrectly? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Labels in Word 2007 Default double spacing | Page Layout | |||
only top three labels merges in mail merge in 2007 | Mailmerge | |||
Merge excel 2007 to word 2007 in labels | Mailmerge | |||
Word 2007 Mail Merge through Excel | Mailmerge | |||
Mail Merge Labels in Word 2007 | Formatting Long Documents |