Conditional mail merge from Contacts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Terry Lemons - 18 Dec 2007 04:11 GMT

Hi

I know how to do a mail merge between contacts in Outlook 2003 and Word
2003. But I need to do some programming/substitution for our holiday card
labels.

If an Outlook field (that I need to choose) contains the word 'Family', then
I want to print "The [Lastname] Family" for this contact, instead of printing
"[Firstname Lastname]". Can I do this kind of conditional logic, from a list
of contacts, in Word Mail Merge? If so, where should I look for
samples/ideas?

Thanks!
tl

Reply to this Message

Graham Mayor - 18 Dec 2007 06:55 GMT

You could use the categories field or one of the four user fields, then
provided you start the merge from Outlook
http://www.gmayor.com/mailmerge_from_outlook.htm you could use a conditional
field

{IF {Mergefield User_Field_1} = "Family" "The {LastName} Family" "{First
Name} {LastName}"
or
{IF {Mergefield Categories} = "Family" "The {LastName} Family" "{First Name}
{LastName}"

Signature

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

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

> Hi
>
[quoted text clipped - 10 lines]
> Thanks!
> tl

Reply to this Message

Terry Lemons - 02 Jan 2008 01:28 GMT

Thanks very much for taking the time to reply. Thanks to your help, it's now
working just as I needed.

Thanks
tl

Reply to this Message