Thread: If statements
View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
dleo dleo is offline
external usenet poster
 
Posts: 9
Default If statements

Is there a way to use IF statements within a mail merge? I'm using an excel
file as my data source. I have the prefix merge field, but about half of the
data entries have none. So when I merge in Word, the prefix field is skipped
(as it should), but I still get that space in between where the prefix would
go and the person's first name. Is there some sort of IF field where I could
basically say "if there IS a prefix put in the space, but if there isn't,
don't put a space."

I hope that makes sense.