Reply
 
Thread Tools Display Modes
  #1   Report Post  
Brian Ellis
 
Posts: n/a
Default Mail Merge Label layout.

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.
  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

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_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

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



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


  #3   Report Post  
Brian Ellis
 
Posts: n/a
Default

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.


"Graham Mayor" wrote in message
...
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_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

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



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




  #4   Report Post  
Graham Mayor
 
Posts: n/a
Default

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.

--

Graham Mayor - Word MVP

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




Brian Ellis wrote:
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.


"Graham Mayor" wrote in message
...
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_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

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



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



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 02:55 AM
mail merge only prints one label per page Golpher Mailmerge 1 December 9th 04 01:47 AM
Mail merge toolbar unavailable after SP3 R Scott Lowden Mailmerge 1 December 1st 04 07:24 PM
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements Mark V Mailmerge 8 November 30th 04 02:31 PM
How do you set up a label mail merge with Excel as source in 2003. Psychic Mom Mailmerge 1 November 27th 04 04:03 PM


All times are GMT +1. The time now is 10:10 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"