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

M

MCStuff

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

Doug Robbins - Word MVP

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top