I'm working through my very first mail merge and have run into an issue
which I can't solve quickly by searching google and was hoping someone could
help. I'm an MVP but **not** a Word MVP. :-)

I would like to acheive the following in a single location in my mail merge
result (labels if you care). My data is in excel and among other data are
fields P1-P8 and J1-J8. I would like the merged result to be "the value of
P1 if it's not blank, otherwise the value of J1". I'll repeat for 2-8. I
saw that I can do "if the value of P1 is blank, use THIS text otherwise use
THAT text". I don't want conditional TEXT, I want conditional FIELD. Can
this be done?

Oh yeah - I would ideally like:
"and if using J1 use background color XX (not looked up - hard coded color
is fine)"

Thanks in advance

--
Gordon Smith (eMVP)

You can use a mergefield in place of the conditional text,

{ IF { MERGEFIELD P1 } "" { MERGEFIELD P1 } { MERGEFIELD J1 } }

Use Ctrl+F9 for each pair of field delimiters { } and Alt+F9 to toggle off
their display.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Gordon Smith (eMVP)" wrote in message
...
I'm working through my very first mail merge and have run into an issue
which I can't solve quickly by searching google and was hoping someone
could help. I'm an MVP but **not** a Word MVP. :-)

I would like to acheive the following in a single location in my mail
merge result (labels if you care). My data is in excel and among other
data are fields P1-P8 and J1-J8. I would like the merged result to be
"the value of P1 if it's not blank, otherwise the value of J1". I'll
repeat for 2-8. I saw that I can do "if the value of P1 is blank, use
THIS text otherwise use THAT text". I don't want conditional TEXT, I want
conditional FIELD. Can this be done?

Oh yeah - I would ideally like:
"and if using J1 use background color XX (not looked up - hard coded color
is fine)"

Thanks in advance

--
Gordon Smith (eMVP)