Can I set up a merge field to convert a numerical value into text?

[JB]

I want to create a mail merge document that will take numerical data from a
spreadsheet and convert it into text, eg a value of 1 in the spreadsheet will
display as a specific phrase in word, a value of 2 will display a different
phrase, etc. Is this possible?

 

[Doug Robbins - Word MVP]

That can be done using an If...then...Else... field construction

{ IF { MERGEFIELD fieldname } = 1 "Display this text because the field
contains 1" "Display this other text because the field does not contain 1" }

You can "nest" such fields if you want to test for more than just two
values.

You must use Ctrl+F9 to insert each pair of field delimiters { } - it will
not work if you enter them directly from the keyboard, and you use 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