Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Mail merge problem

Apr 26, 2005 9:30PM PDT

I have been working with a database in MS Excel. Some of the columns include date information in the following format DD/MM/YY however some of the cells contain the text "N/A". I can not seem to migrate this text across on the merge as they are coming across as 01/04/05.

The Toggle for the merge is:

MERGEFIELD First_Board_T \@"YY"

How do it tell word that some of the data will be text as well as date formula?

Grateful for your assistance.

Loz

Discussion is locked

- Collapse -
Re: mail merge problem
Apr 26, 2005 11:22PM PDT

Make a new column in Excel, using an IF to discriminate between Not available (ISNA) and available, and FORMAT to format the date as you like to see it printed.
Then use this column in Word as a text field, not as a date field.

It's kind of a work-around, but quite workable.

Kees

- Collapse -
mail merge problem
Apr 27, 2005 1:15AM PDT

Thanks for you help but can you be a bit more specific. What would be the =IF????? and FORMAT????

Thanks

L

- Collapse -
Re: if and format
Apr 27, 2005 4:30AM PDT