[Mary jane]

Everytime I try to mail merge labels from a data source, whether Excel or
Word database, the lables merge incorrectly. I.E. I get the first address in
the list in the first label of the page and the second on a NEW page of
labels with all other labels on the page blank. I troubleshooted to no end
and can successfully merge letters and envelopes but not labels

[Andrea Jones]

What version of Word are you using? Before you run the merge do you see the
merge fields on all your labels on the page? It may be that you haven't
replicated the fields to the other labels on the page.

Andrea Jones

"Mary jane" wrote:

Everytime I try to mail merge labels from a data source, whether Excel or
Word database, the lables merge incorrectly. I.E. I get the first address in
the list in the first label of the page and the second on a NEW page of
labels with all other labels on the page blank. I troubleshooted to no end
and can successfully merge letters and envelopes but not labels

[Doug Robbins - Word MVP]

See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Mary jane" wrote in message
...
Everytime I try to mail merge labels from a data source, whether Excel or
Word database, the lables merge incorrectly. I.E. I get the first address
in
the list in the first label of the page and the second on a NEW page of
labels with all other labels on the page blank. I troubleshooted to no
end
and can successfully merge letters and envelopes but not labels

[Mary jane]

I am using 2003 and no I do not see the merge fields on the labels, do they
have to be pulled into every label manually?

"Andrea Jones" wrote:

What version of Word are you using? Before you run the merge do you see the
merge fields on all your labels on the page? It may be that you haven't
replicated the fields to the other labels on the page.

Andrea Jones

"Mary jane" wrote:

Everytime I try to mail merge labels from a data source, whether Excel or
Word database, the lables merge incorrectly. I.E. I get the first address in
the list in the first label of the page and the second on a NEW page of
labels with all other labels on the page blank. I troubleshooted to no end
and can successfully merge letters and envelopes but not labels

[Mary jane]

I'll check out the article, and once again it is always a relief to find out
it is the program, not you, I hope 2007 has better merge capabilities

"Doug Robbins - Word MVP" wrote:

See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Mary jane" wrote in message
...
Everytime I try to mail merge labels from a data source, whether Excel or
Word database, the lables merge incorrectly. I.E. I get the first address
in
the list in the first label of the page and the second on a NEW page of
labels with all other labels on the page blank. I troubleshooted to no
end
and can successfully merge letters and envelopes but not labels

[Doug Robbins - Word MVP]

There is a Propogate Labels button on the mail merge toolbar that I suggest
that you activate by selecting Toolbars from the View menu and then check
the Mail Merge item.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Mary jane" wrote in message
...
I am using 2003 and no I do not see the merge fields on the labels, do they
have to be pulled into every label manually?

"Andrea Jones" wrote:

What version of Word are you using? Before you run the merge do you see
the
merge fields on all your labels on the page? It may be that you haven't
replicated the fields to the other labels on the page.

Andrea Jones

"Mary jane" wrote:

Everytime I try to mail merge labels from a data source, whether Excel
or
Word database, the lables merge incorrectly. I.E. I get the first
address in
the list in the first label of the page and the second on a NEW page of
labels with all other labels on the page blank. I troubleshooted to no
end
and can successfully merge letters and envelopes but not labels

[Mary jane]

okay I really hate it when I troubleshoot for hours and find out it was a
click of the mouse!

Thanks!

"Andrea Jones" wrote:

What version of Word are you using? Before you run the merge do you see the
merge fields on all your labels on the page? It may be that you haven't
replicated the fields to the other labels on the page.

Andrea Jones

"Mary jane" wrote:

Everytime I try to mail merge labels from a data source, whether Excel or
Word database, the lables merge incorrectly. I.E. I get the first address in
the list in the first label of the page and the second on a NEW page of
labels with all other labels on the page blank. I troubleshooted to no end
and can successfully merge letters and envelopes but not labels

[Graham Mayor]

It is not the program. It is merely that you have not followed all the steps
in the wizard correctly. The link to my web page posted by Doug shows in
simple diagrams how to do it either with the wizard or the toolbar. Mail
merge in Word really is simple, but it does have some quirks. I can't see it
changing much in 2007!

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Mary jane wrote:
I'll check out the article, and once again it is always a relief to
find out it is the program, not you, I hope 2007 has better merge
capabilities

"Doug Robbins - Word MVP" wrote:

See the article "Mailmerge Labels with Word XP" on fellow MVP Graham
Mayor's website at

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Mary jane" wrote in message
...
Everytime I try to mail merge labels from a data source, whether
Excel or Word database, the lables merge incorrectly. I.E. I get
the first address in
the list in the first label of the page and the second on a NEW
page of labels with all other labels on the page blank. I
troubleshooted to no end
and can successfully merge letters and envelopes but not labels