reading data inaccurately when merging from Excel to Word

[Loz]

I am trying to merge from Excel into Word. One of the columns contains date
format data which is generated by a forumal. The same column also contains
some records which return "N/A" and is in text format, manually imputted.

The merge instruction within Word is:

MERGEFIELD First_Board_T \@"YY"

However this will not recognise "N/A" and merges this entry as a date.

How can I tell word to migrate the exact data contained within the column?

Grateful for your assistance.

Loz

 

[Graham Mayor]

You will need a conditional field
{IF {MERGEFIELD First_Board_T} <> "N/A" "{MERGEFIELD First_Board_T \@
"YY"}" "N/A"}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>