How do I insert extra fields in Address Block for Mail Merge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gill Sequitur - 23 Aug 2006 12:19 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 23 Aug 2006 12:24 GMT

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

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

>I need to include more fields in the Address Block - such as Job Title,
>extra
[quoted text clipped - 4 lines]
> to ensure that empty fields do not appear in the layout that appears on
> letter or envelope?

Reply to this Message

Gill Sequitur - 23 Aug 2006 12:51 GMT

> Don't use the AddressBlock, just insert the fields that you want to use in
> the configuration that you want.
[quoted text clipped - 9 lines]
>
>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 to this Message

Graham Mayor - 23 Aug 2006 13:54 GMT

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

Signature

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

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

>> Don't use the AddressBlock, just insert the fields that you want to
>> use in
[quoted text clipped - 22 lines]
>> a means of ensuring that blank fields do not appear as a space or
>> empty line please?

Reply to this Message