Address Filtering

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

- 09 Jul 2004 15:31 GMT

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?

Reply to this Message

Graham Mayor - 10 Jul 2004 09:00 GMT

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

Signature

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

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

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

Reply to this Message