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

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

"barbtries" wrote in message
...
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

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?

"barbtries" wrote:

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

"recyclemichelle" wrote:

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?

"barbtries" wrote:

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-

[RPMitchal]

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


"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

"barbtries" wrote in message
...
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

[Peter Jamieson]

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

"RPMitchal" wrote in message
...
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


"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

"barbtries" wrote in message
...
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

[RPMitchal]

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


"Peter Jamieson" wrote:

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

"RPMitchal" wrote in message
...
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


"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

"barbtries" wrote in message
...
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

[RPMitchal]

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

"recyclemichelle" wrote:

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?

"barbtries" wrote:

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

[Peter Jamieson]

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
"RPMitchal" wrote in message
...
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


"Peter Jamieson" wrote:

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

"RPMitchal" wrote in message
...
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


"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

"barbtries" wrote in message
...
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

[Graham Mayor]

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.

--

Graham Mayor - Word MVP

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


RPMitchal wrote:
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

"recyclemichelle" wrote:

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?

"barbtries" wrote:

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

[Doug Robbins - Word MVP]

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


--
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

"RPMitchal" wrote in message
...
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

"recyclemichelle" wrote:

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?

"barbtries" wrote:

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

[RPMitchal]

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

"Doug Robbins - Word MVP" wrote:

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


--
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

"RPMitchal" wrote in message
...
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

"recyclemichelle" wrote:

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?

"barbtries" wrote:

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

[lah]

I'm having a similar problem, only i'm using mass data and only 1 page of
labels has addresses when i complete the merge??, there should be around 15
pages worth of labels, can anyone HELP!

"barbtries" wrote:

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

[Graham Mayor]

You have not completed the merge. You must merge to the printer or to a new
document. See
http://www.gmayor.com/mail_merge_lab...#only_one_page

--

Graham Mayor - Word MVP

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



lah wrote:
I'm having a similar problem, only i'm using mass data and only 1
page of labels has addresses when i complete the merge??, there
should be around 15 pages worth of labels, can anyone HELP!

"barbtries" wrote:

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

[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

or "Mail Merge with Word 2007" on fellow MVP Graham Mayor's website at

http://www.gmayor.com/merge_labels_with_word_2007.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

"lah" wrote in message
...
I'm having a similar problem, only i'm using mass data and only 1 page of
labels has addresses when i complete the merge??, there should be around
15
pages worth of labels, can anyone HELP!

"barbtries" wrote:

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