Can I set up a merge field to convert a numerical value into text?
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
"JB" wrote in message
...
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?
|