Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / September 2005

Tip: Looking for answers? Try searching our database.

Automatically removing Next Record

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PeteB - 11 Sep 2005 08:28 GMT
I want to create multiple mailing labels for one record in my data source.
How do I prevent the Next Record from automatically appearing when I create
my labels?
Do I have to remove them manually from all 29 labels?
Graham Mayor - 11 Sep 2005 10:25 GMT
Create the label document first from the new document option in the
envelope/label wizard, then use this as the basis for a form letter merge
(rather than a label type merge). Put your next record fields wherever you
want them.

Signature

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

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

> I want to create multiple mailing labels for one record in my data
> source. How do I prevent the Next Record from automatically appearing
> when I create my labels?
> Do I have to remove them manually from all 29 labels?
PeteB - 11 Sep 2005 17:25 GMT
Ok, I got the fields in place, but the Propagate button is grayed out. I
would like to roll out the same fields to every label without having to
customize every label. Is that possible?
The key here is that I don't want Next Record at all. I need the same
address on every label.
Thanks for the help.

> Create the label document first from the new document option in the
> envelope/label wizard, then use this as the basis for a form letter merge
[quoted text clipped - 5 lines]
> > when I create my labels?
> > Do I have to remove them manually from all 29 labels?
Doug Robbins - 11 Sep 2005 22:07 GMT
Use a label type mailmerge and delete the Next Record  field from each of
the labels.  With that arrangement, each new sheet of labels will however
advance to the next record.  If you need more that one page of the same
label, after setting up the labels using the label type main document,
change it to a formletter document and copy and paste the required number of
additional rows.

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

> Ok, I got the fields in place, but the Propagate button is grayed out. I
> would like to roll out the same fields to every label without having to
[quoted text clipped - 13 lines]
>> > when I create my labels?
>> > Do I have to remove them manually from all 29 labels?
Graham Mayor - 12 Sep 2005 06:11 GMT
You want your cake and your ha'penny :)
Propagate will only be available with the document type set to label, but
propagate will add the next fields also. Change the document type to label
propagate the labels, then change it back to form letter and with the field
content displayed (ALT+F9) use the replace function to replace ^d NEXT with
nothing. Then add NEXT fields to the cells where you require them. or leave
them off for a page of labels for each address.

The following macro will do all of this except add the next fields:

Sub DuplicateLabels()

'Change the document type to mailing label
ActiveDocument.MailMerge.MainDocumentType = _
wdMailingLabels

'propagate the labels
WordBasic.MailMergePropagateLabel

'display the field codes so they can be removed
ActiveWindow.View.ShowFieldCodes = True
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting

'search for and remove the {next} fields

'added by the propagation and which are not required
With Selection.Find
.Text = "^d NEXT"
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute replace:=wdReplaceAll

'revert the document type to a normal document
ActiveDocument.MailMerge.MainDocumentType = _

wdFormLetters
End Sub

See http://www.gmayor.com/installing_macro.htm

Signature

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

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

> Ok, I got the fields in place, but the Propagate button is grayed
> out. I would like to roll out the same fields to every label without
[quoted text clipped - 20 lines]
>>> appearing when I create my labels?
>>> Do I have to remove them manually from all 29 labels?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.