Conditional mail merge from Contacts

T

Terry Lemons

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
 
G

Graham Mayor

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


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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
T

Terry Lemons

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

Thanks
tl
 

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