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 / December 2004

Tip: Looking for answers? Try searching our database.

Mail Merge Label layout.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brian Ellis - 09 Dec 2004 00:55 GMT
Why do I get this on the label

Mr B Bloggs
24 The Street
Overthere
WARWICK, Warwickshire, CV11
3GH

when I thought I had laid out this:

Mr B Bloggs
24 The Street
Overthere
WARWICK
Warwickshire
CV11 3GH

I can alter it as often as you like but it comes back wrong.
Word 2002; matching Outlook; label L7161; tried through Word and through Outlook. Contact subfolder looks like the latter layout
Graham Mayor - 09 Dec 2004 07:57 GMT
You appear to be using the address block. Insert the individual fields. If
you start the merge from Outlook you can access *all* the fields. The field
you probably want is the Mailing_Address field. If you start from Word it is
the Postal_Address field you want.

See http://www.gmayor.com/mailmerge_from_outlook.htm
and http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

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

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

Why do I get this on the label

Mr B Bloggs
24 The Street
Overthere
WARWICK, Warwickshire, CV11
3GH

when I thought I had laid out this:

Mr B Bloggs
24 The Street
Overthere
WARWICK
Warwickshire
CV11 3GH

I can alter it as often as you like but it comes back wrong.
Word 2002; matching Outlook; label L7161; tried through Word and through
Outlook. Contact subfolder looks like the latter layout.
Brian Ellis - 09 Dec 2004 12:45 GMT
Thank you Graham. I did not know that Address Block was anything special.
In what must now be 20 hours of trying and searching KB etc I haven't come
across anything defining it as being different from selecting any other
field. You will no doubt tell me where to look.
It has been a frustrating business. I know the programs have to be versatile
in order to cover all the more specialised needs but I would have thought
that a few pre-programmed setups for the most common needs would be
available. Something like 'Click here to print mailing labels for the
Contact subfolder on view onto Avery label Lxxxx'. Now it is like buying a
motor vehicle as a flat pack - assemble in the order of your choice every
time you want to go to the store.
Thanks are due to you for your help.

> You appear to be using the address block. Insert the individual fields. If
> you start the merge from Outlook you can access *all* the fields. The field
[quoted text clipped - 32 lines]
> Word 2002; matching Outlook; label L7161; tried through Word and through
> Outlook. Contact subfolder looks like the latter layout.
Graham Mayor - 09 Dec 2004 17:32 GMT
The addressblock is a special type of field that combines address fields in
a particular manner. It may be fine if you are American, using US format
addresses, but for elsewhere (and probably America also) you have much more
control by inserting the individual fields that you require.

Signature

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

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

> Thank you Graham. I did not know that Address Block was anything
> special. In what must now be 20 hours of trying and searching KB etc
[quoted text clipped - 46 lines]
>> Word 2002; matching Outlook; label L7161; tried through Word and
>> through Outlook. Contact subfolder looks like the latter layout.
 
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.