Mail Merge from Excel - conditional field choice?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gordon Smith (eMVP) - 12 Dec 2005 22:37 GMT

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

Signature

Gordon Smith (eMVP)

Reply to this Message

Doug Robbins - Word MVP - 13 Dec 2005 05:18 GMT

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.

Signature

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

> 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
[quoted text clipped - 13 lines]
>
> Thanks in advance

Reply to this Message

Rate this thread: