Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
If then statements LSivak Mailmerge 1 November 9th 06 12:17 AM
IF statements not working jermsalerms79 Mailmerge 1 April 12th 06 03:34 PM
limits on if statements Robseym Mailmerge 4 March 7th 06 02:08 PM
IF Statements and REF Fields Anna Cooper Microsoft Word Help 1 October 15th 05 06:12 AM
financial statements Chris Microsoft Word Help 2 December 1st 04 03:08 AM


All times are GMT +1. The time now is 12:23 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"