merge data w/two addresses only using one if other is empty

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MCStuff - 07 Nov 2005 23:01 GMT

I have a standard envelope to merge data from excel worksheet that has two
addresse fields, Property Address and Mailing Address, I need to have the
Mailing Address to print on envelope, but if that field is blank, need the
Property
Address to print. I tried to use the Insert Word Field, but the If Then
Else feature does not work. Also how do I turn on and off the toggle codes?

Reply to this Message

Doug Robbins - Word MVP - 08 Nov 2005 05:44 GMT

Use Alt+F9 to toggle the display of field codes

{ IF { MERGEFIELD MailingAddress } <> "" { MERGEFIELD MailingAddress} {
MERGEFIELD PropertyAddress } }

where you use Ctrl+F9 to insert each pair of field delimiters { }

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 have a standard envelope to merge data from excel worksheet that has two
> addresse fields, Property Address and Mailing Address, I need to have the
[quoted text clipped - 3 lines]
> Else feature does not work. Also how do I turn on and off the toggle
> codes?

Reply to this Message