mail merge from excel-date in excel January 1, 2005 -merged dbase.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elaine Ballon - 22 Dec 2005 18:13 GMT

I have an excel database with dates. I have formatted the dates in excel so
they are January 1, 2006 - When I do a merge using my excel sheet as the
information database, the columns that have the date spelled out change to a
date of 1/1/06. What can I do so the date colums format does not change
during the merge.

Reply to this Message

Graham Mayor - 23 Dec 2005 08:31 GMT

Word ignores any formatting from Excel so you have to apply it in Word using
a formatting switch http://www.gmayor.com/formatting_word_fields.htm
In this case {Mergefield datefieldname \@ "MMMM d, yyyy"}

Signature

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

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

> I have an excel database with dates. I have formatted the dates in
> excel so they are January 1, 2006 - When I do a merge using my excel
> sheet as the information database, the columns that have the date
> spelled out change to a date of 1/1/06. What can I do so the date
> colums format does not change during the merge.

Reply to this Message