B
barbtries
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
merge only one label has an address on it
D
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_labels_with_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
website at
http://www.gmayor.com/mail_merge_labels_with_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
R
recyclemichelle
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?
the data fields you wanted? Are all your records selected with checkmarks?
B
barbtries
recyclemichelle said:
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-
R
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
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
P
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/?
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?
It depends on what it contains.
Peter Jamieson
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/?
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?
It depends on what it contains.
Peter Jamieson
R
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
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
R
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
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
P
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
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
G
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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
D
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
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
R
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
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
L
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!
labels has addresses when i complete the merge??, there should be around 15
pages worth of labels, can anyone HELP!
G
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_labels_with_word_xp.htm#only_one_page
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
document. See
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm#only_one_page
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
D
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_labels_with_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
website at
http://www.gmayor.com/mail_merge_labels_with_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