J
JB reluctantly from WP
Hello,
I have an Excel database file, and am merging into a Word document. I am
familiar with Word's merge process.
I need to display mergefields "LAST_NAME, FIRST_NAME" but only want the
comma if FIRST_NAME field is not blank. When FIRST_NAME field is blank, I
only want to diplay the LAST_NAME field. I'm having a heckuva time trying to
get the right IF statement to produce the wanted results.
My attempt at the IF statement: {IF {MERGEFIELD "FIRST_NAME"} <> "" "
{MERGEFIELD "LAST_NAME"},"} {MERGEFIELD "FIRST_NAME"}
I have a feeling I'm really close! However, the results produced by this
statement resulted in the last name not printing at all if the first name was
blank.
Any assistance is greatly appreciated!
~Julie
I have an Excel database file, and am merging into a Word document. I am
familiar with Word's merge process.
I need to display mergefields "LAST_NAME, FIRST_NAME" but only want the
comma if FIRST_NAME field is not blank. When FIRST_NAME field is blank, I
only want to diplay the LAST_NAME field. I'm having a heckuva time trying to
get the right IF statement to produce the wanted results.
My attempt at the IF statement: {IF {MERGEFIELD "FIRST_NAME"} <> "" "
{MERGEFIELD "LAST_NAME"},"} {MERGEFIELD "FIRST_NAME"}
I have a feeling I'm really close! However, the results produced by this
statement resulted in the last name not printing at all if the first name was
blank.
Any assistance is greatly appreciated!
~Julie