reading data inaccurately when merging from Excel to Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Loz - 28 Apr 2005 19:42 GMT

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

Reply to this Message

Graham Mayor - 29 Apr 2005 00:02 GMT

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

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 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
[quoted text clipped - 13 lines]
>
> Loz

Reply to this Message