Address Filtering

[Guest]

Is there any way to filter addresses in a mail merge. For
example, some contacts may have Home & company address. I
have to include both fields in the merge document
template, but is there a "if... then" feature so that if
there is a home address, it will not merge company
information?

 

[Graham Mayor]

You can certainly use a series of conditional fields eg

{IF {Mergefield Company} <> "" "{Mergefield BusinessStreet}" "{Mergefield
HomeStreet}"}
{IF {Mergefield Company} <> "" "{Mergefield BusinessTown}" "{Mergefield
HomeTown}"}
etc

Or if the addresses are from Outlook, start the merge from Outlook and merge
the MailingAddress field.
http://www.gmayor.com/mailmerge_from_outlook.htm

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>