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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JB - 20 Nov 2006 03:21 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 20 Nov 2006 04:02 GMT

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.

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 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?

Reply to this Message