If statements in merge docs (Word 2000)

Topic

New Reply

I need to create a mail merge letter that pulls data in from one of two places in an Excel spreadsheet. If the first field is empty, it pulls in the data from a second field. which will always have data.

I’ve tried everything I can think of and all that the help file has to offer under “IF…then…else”, but I’m getting nowhere. Is there a trick to this?

Thanks in advance for your assistance!

Reply | Quote

Replies

Check this site http://www.mvps.org/word/FAQs/index6.html
I think you’ll find your answer.
Peter Herworth

GeoffW – hyperlinks added

Reply | Quote

Look into the IF field (not statement). See by Dave Rado. For more on mailmerge and fields, follow the links at Web Resources – Mail Merge.

Hope this helps.

Reply | Quote

You could always create an additional field in th Excel file, which holds the first value where available or the second if the first is blank. If your two existing fields are in A1 and B1 you could have the following formula in C1 :

IF(A1=””,B1,A1). You could then use column C as the merge field, which should have the correct value in all cases.

Andrew C

Reply | Quote

{ IF { MERGEFIELD FieldOne } = “” “{ MERGEFIELD FieldTwo }” “{ Mergefield FieldOne }” }
where curly brackets are inserted with Ctrl+F9. This says if mergefield one is blank, use field2, else use field1.

Just remember that the field in Excel must actually be empty.

Hope this helps.

Reply | Quote