[aedcone]

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?

[Graham Mayor]

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?

[aedcone]

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?

[Graham Mayor]

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?