Computer Forum Forum Index
Register  FAQ Profile Log in to check your private messages Log in Register 

Conditional mail merge from Contacts

 
Post new topic   Reply to topic    Computer Forum Forum Index -> word mailmerge fields
View previous topic :: View next topic  
Author Message
Terry Lemons
Guest





PostPosted: Tue Dec 18, 2007 4:11 am    Post subject: Conditional mail merge from Contacts Reply with quote

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
Back to top
Google
Sponsor





PostPosted: Tue Dec 18, 2007 4:11 am    Post subject: Advertisement

Back to top
Graham Mayor
Guest





PostPosted: Tue Dec 18, 2007 6:55 am    Post subject: Re: Conditional mail merge from Contacts Reply with quote

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

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

Terry Lemons wrote:
Quote:
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
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Computer Forum Forum Index -> word mailmerge fields All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Computer Forum