my labels aren't merging

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

barbtries - 04 May 2006 20:43 GMT

i'm trying to do a mail merge for address labels but when i complete the
merge only one label has an address on it

Reply to this Message

Doug Robbins - Word MVP - 04 May 2006 22:34 GMT

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

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

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

> i'm trying to do a mail merge for address labels but when i complete the
> merge only one label has an address on it

Reply to this Message

RPMitchal - 11 Jun 2007 17:17 GMT

Word 2003

I am having the devil of a time with the Mail/Merge for labels. Although I
have studied the Article by Graham Mayor as listed below, I remain unable to
make heads or tails of my label situation.

The labels in question are from an online company and do not fit within any
familiar parameters. I have downloaded the company's Template for Word and
the layout matches the labels I have in hand.

Is it possible to merely use an established Template (as downloaded from the
online site) or to use an existing Document layout for label mail/merges?

When I attempt to use the Template, having chosen my data file, I do not get
the automatic "Next Record" fields.

Thanks much - RPM

> See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 3 lines]
> > i'm trying to do a mail merge for address labels but when i complete the
> > merge only one label has an address on it

Reply to this Message

Peter Jamieson - 11 Jun 2007 20:13 GMT

Can you describe in more detail what format the labels are in (e.g. are they
in a WOrd document? a .txt file? something else? and how they are laid out?
If nothing else, can you provide a simple example of what they /look like/?

> I have downloaded the company's Template for Word and
> the layout matches the labels I have in hand.

What is this template? Is it a WOrd document with a layout? Is it a .doc or
a .dot file, or what? Do you feel able to point us to the site where you got
it, and do you think we would be able to get it as well without having to
sign up for something?

> Is it possible to merely use an established Template (as downloaded from
> the
> online site) or to use an existing Document layout for label mail/merges?

It depends on what it contains.

Peter Jamieson

> Word 2003
>
[quoted text clipped - 29 lines]
>> > the
>> > merge only one label has an address on it

Reply to this Message

RPMitchal - 11 Jun 2007 23:22 GMT

Hello Peter:

I have the template in both a .doc and .dot format. The labels are oval
(landscape) and are laid out numbering 5 across and 11 down with about a
0.25" horizontal spacing between each row. Each label measures 1.5 wide x
0.75 high.

I have tried to use Word to recreate the template layout and to save it as a
custom set up label, but the ability does not seem to exist to account for
the 0.25" spacing between each row. I end up with 5 across and 11 down, but
with no spacing between the rows.

The site for the label template is www.onlinelabels.com and the particular
label No. is OL6025GF.

The disconnect with this mail/merge seems to be the fact that the template
or document layout already exists, but in using the "start from existing
document" option I am not presented with the option to "update all labels"
and Word treats it as a letter.

However, if I use any of the label layouts that exist within the "Labels
Option" category, the mail/merge works just fine. Perhaps there is a way to
add the template or existing document layout into the "labels option"
category?

Gosh. Trying to describe this situation in a way that would hopefully make
sense has been quite the undertaking. Now I need a nap! :-)

Thanks in advance for any assistance you may provide - RPM

> Can you describe in more detail what format the labels are in (e.g. are they
> in a WOrd document? a .txt file? something else? and how they are laid out?
[quoted text clipped - 49 lines]
> >> > the
> >> > merge only one label has an address on it

Reply to this Message

Peter Jamieson - 12 Jun 2007 03:19 GMT

OK, try the following:
a. open the downloaded document 6025.doc
b. enable the mailmerge toolbar (e.g. via View|Toolbars)
c. click the first button and select the Labels option
d. cancel out of the dialog box that appears
e. save the document as 6025L.doc or whatever you want
f. connect the data source
g. insert a field in cell 1
h. locate and click the Propagate Labels button (it/s about 11 from the
left)

Unfortunately I can't completely verify that this works correctly on Word
2003 as I have the "Tablet PC" problem which means replication doesn't work
properly, but
i. Word certainly does not need any { NEXT } fields to do the replication.
It should add them in
j. if the "spacer" rows (row 2,4,6 etc.) end up with fields in them after
Propagate Labels, you'll need another approach. There are some macros at

http://tips.pjmsn.me.uk/t0005.htm

The first of those might work if you also add { NEXT } fields in your .doc
in every "label" cell except the first. However, the macro may need some
tweaking to deal with the "spacer" rows, and the second macro definitely
needs to be changed to cope with that. But if you need to resort to a macro,
let me know and I'll try to do the necessary modifications. in the next 24
hours.

Peter Jamieson

> Hello Peter:
>
[quoted text clipped - 95 lines]
>> >> > the
>> >> > merge only one label has an address on it

Reply to this Message

recyclemichelle - 04 May 2006 22:55 GMT

Did you try the "Update All Labels" button after you formatted the label with
the data fields you wanted? Are all your records selected with checkmarks?

> i'm trying to do a mail merge for address labels but when i complete the
> merge only one label has an address on it

Reply to this Message

barbtries - 04 May 2006 23:11 GMT

> Did you try the "Update All Labels" button after you formatted the label with
> the data fields you wanted? Are all your records selected with checkmarks?
>
> > i'm trying to do a mail merge for address labels but when i complete the
> > merge only one label has an address on it

thanks to all for responding...michelle hit the nail on the head - while
waiting for responses i tried the merge for about the 15th time and it
worked! busily sticking labels on postcards now...thanks again-

Reply to this Message

RPMitchal - 11 Jun 2007 23:28 GMT

Recyclemichelle:

Yes to both of your questions/suggestions.

It seems that unless I use a label setup that currently exists with the
"labels option", I am not afforded the "update all labels" option and this
particular layout does not currently exist within the "labels option" and I
have been unsuccessful in my attempts to recreate it so as to save it under
"other/custom". :-(

Thanks - RPM

Reply to this Message

Graham Mayor - 12 Jun 2007 07:17 GMT

Not so. Open the table document, activate the merge toolbar and set the
document type to Mailing labels. Cancel the label selection dialog when it
pops up and the document type remains selected as labels. It is the document
type that determines whether you can propagate. I will make this clearer on
my web page when I have time to do some maintenance.

Signature

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

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

> Recyclemichelle:
>
[quoted text clipped - 14 lines]
>>> i'm trying to do a mail merge for address labels but when i
>>> complete the merge only one label has an address on it

Reply to this Message

Doug Robbins - Word MVP - 12 Jun 2007 09:23 GMT

Or you can use the following macro to propogate the information to all of
the labels on the sheet.

Macro to overcome the problem with propagation of mail merge field fields
with a label type mail merge when using a Tablet PC and some other Computers
that have Tablet PC Functionality available:

Sub MailMergePropagateLabel()

Dim atable As Table

Dim i As Long, j As Long

Dim source As Cell, target As Cell

Dim myrange As Range

Set atable = ActiveDocument.Tables(1)

Set source = atable.Cell(1, 1)

Set myrange = source.Range

myrange.Collapse wdCollapseStart

ActiveDocument.Fields.Add Range:=myrange, Text:="NEXT", _

PreserveFormatting:=False

source.Range.Copy

For j = 2 To atable.Columns.Count

Set target = atable.Cell(1, j)

If target.Range.Fields.Count > 0 Then

target.Range.Paste

End If

Next j

For i = 2 To atable.Rows.Count

For j = 1 To atable.Columns.Count

Set target = atable.Cell(i, j)

If target.Range.Fields.Count > 0 Then

target.Range.Paste

End If

Next j

Next i

atable.Cell(1, 1).Range.Fields(1).Delete

End Sub

Signature

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

> Recyclemichelle:
>
[quoted text clipped - 18 lines]
>> > the
>> > merge only one label has an address on it

Reply to this Message

RPMitchal - 18 Jun 2007 22:37 GMT

Ladies and Gents:

First of all, my apologies for not responding with my appreciation prior to
now. I had no idea that these responses were out here in the Forum. Guess I
neglected to "check" the "notify me of replies" box.

However, since this weekly project came up once again, I revisited the
information as presented earlier by Graham Mayor and things went
"swimmingly". Whew!

Peter: I'm sorry that you seemed to have gone to so much trouble in this
regard for me, but be assured that it was very much appreciated.

Thanks to one and all - RPM

> Or you can use the following macro to propogate the information to all of
> the labels on the sheet.
[quoted text clipped - 81 lines]
> >> > the
> >> > merge only one label has an address on it

Reply to this Message

Rate this thread: