Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Gill Sequitur Gill Sequitur is offline
external usenet poster
 
Posts: 1
Default How do I insert extra fields in Address Block for Mail Merge?

I need to include more fields in the Address Block - such as Job Title, extra
address lines etc to match my database. I could insert the fields separately
in the Merge, instead of using the preset Address block, but is it possible
to ensure that empty fields do not appear in the layout that appears on
letter or envelope?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default How do I insert extra fields in Address Block for Mail Merge?

Don't use the AddressBlock, just insert the fields that you want to use in
the configuration that you want.

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

"Gill Sequitur" Gill wrote in message
...
I need to include more fields in the Address Block - such as Job Title,
extra
address lines etc to match my database. I could insert the fields
separately
in the Merge, instead of using the preset Address block, but is it
possible
to ensure that empty fields do not appear in the layout that appears on
letter or envelope?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Gill Sequitur Gill Sequitur is offline
external usenet poster
 
Posts: 1
Default How do I insert extra fields in Address Block for Mail Merge?



"Doug Robbins - Word MVP" wrote:

Don't use the AddressBlock, just insert the fields that you want to use in
the configuration that you want.

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

"Gill Sequitur" Gill wrote in message
...
I need to include more fields in the Address Block - such as Job Title,
extra
address lines etc to match my database. I could insert the fields
separately
in the Merge, instead of using the preset Address block, but is it
possible
to ensure that empty fields do not appear in the layout that appears on
letter or envelope?



Thanks - I tried that but I have many countries in the database and do not want UK to appear on UK addresses. Address block does that automatically - Is there a way of doing this myself? Also is there a means of ensuring that blank fields do not appear as a space or empty line please?

  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default How do I insert extra fields in Address Block for Mail Merge?

The addressblock field dows not work properly outside the US. The
postal_address field in Outlook will remove United Kingdom automatically,
alternatively you can conditionally insert the country eg

{IF {Mergefield Country} "United K*" "{Mergefield Country}"}

--

Graham Mayor - Word MVP

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


Gill Sequitur wrote:
"Doug Robbins - Word MVP" wrote:

Don't use the AddressBlock, just insert the fields that you want to
use in
the configuration that you want.

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

"Gill Sequitur" Gill wrote in
message
...
I need to include more fields in the Address Block - such as Job
Title, extra
address lines etc to match my database. I could insert the fields
separately
in the Merge, instead of using the preset Address block, but is it
possible
to ensure that empty fields do not appear in the layout that
appears on letter or envelope?



Thanks - I tried that but I have many countries in the database and
do not want UK to appear on UK addresses. Address block does that
automatically - Is there a way of doing this myself? Also is there
a means of ensuring that blank fields do not appear as a space or
empty line please?



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
Insert merge fields from list in the Subject line TimE Mailmerge 3 June 8th 06 04:45 AM
New fields do not show in a merged letter when using Address Block angelaoak24 Mailmerge 5 December 15th 05 05:34 PM
Insert Address Button v. Envelopes Joe McGuire Microsoft Word Help 2 December 14th 05 06:03 AM
Mail Merge Address Block Missing Address 3 Joe Champagne Mailmerge 3 September 23rd 05 06:09 PM
Insert merge fields C Tate Page Layout 6 November 27th 04 03:04 PM


All times are GMT +1. The time now is 06:38 PM.

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"