View Single Post
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Jean-Guy Marcil[_2_] Jean-Guy Marcil[_2_] is offline
external usenet poster
 
Posts: 373
Default IF THEN Statements for Mail Merge in Word 2007

"IT/Marketing Consultant @ Pharmacist_CA" wrote:

I'm trying to do a mailing where I need to use an IF THEN ELSE statement.
I'm importing data from an Excel spreadsheet. Currently (please correct me
if I am wrong), it does not appear that I can do the following statement in
Word 2007. I have two fields 'Goes By' and 'First Name'. What I want to do
is create a statement that reads:

IF Goes By is blank THEN First Name


Try:

{IF {MERGEFIELD GoesBy} = "" {MERGEFIELD First_Name} {MERGEFIELD GoesBy}}

Where all {} pairs are inserted via CTRL-F9.