Mail Merge "If" Field 2

[ssVBAdev]

I'm creating a Mail Merge Letter and would like the merge to include, or not include, text based on data info. For instance:

If there is not a Fax number don't have the "Fax:" line...
If there is not a Job Title entered then don't include the "," after the last name...

The formula I have for the MergeField in the letter does not seem to work:

{ IF JobTitle <> &quot;&quot; &quot;,&quot; &quot;&quot; }
This field is right after the Last Name field and before the Job Title field. So, if there is no Job Title the &quot;,&quot; should not show up...

Any suggestions??

 

[carrr]

Check this out for some inspiration:

http://www.mvps.org/word/FAQs/MailMerge/MMergeIfFields.htm

 

[ssVBAdev]

Works for me! Thanks. Star for you.

 

[muffingal]

Thanks carrr! It worked for me too! I gave ya a star too!