mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

maciver10@gmail.com - 11 Jan 2007 16:12 GMT

I am trying to merge information from a document from excel into a
letter document in word. What I would like to do is have the if..then
statement read as such:

If Row 1/Column B value is "college" then insert value from Row
1/Column C. I would like to do this for numerous different if..then
statements throughout the letter.

The only way I can figure out how to possibly do it is to do the
if..then statement in excel and merge the new column into word. I'm
hoping to find a way to do it in Word.

Reply to this Message

Doug Robbins - Word MVP - 11 Jan 2007 18:15 GMT

Note, Row 1 is where the names of your mergefields should be entered, so I
assume that you mean Row 2/Column B

You can do it with an If...then...Else field in Word

{ IF { MERGEFIELD ColumnB } = "college" { MERGEFIELD ColumnC } }

Replace ColumnB and ColumnC in the above with the names of the mergefields
for the data in those columns. You must use Ctrl+F9 to insert each pair of
field delimiters { } and you use Alt+F9 to toggle off their display.

You did not say what you want inserted if the data in ColumnB is not
"college" If there is something that you want to display in that case, it
gets entered between the } }, leaving a space between the first } and
whatever it is that you want to appear.

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 am trying to merge information from a document from excel into a
> letter document in word. What I would like to do is have the if..then
[quoted text clipped - 7 lines]
> if..then statement in excel and merge the new column into word. I'm
> hoping to find a way to do it in Word.

Reply to this Message