Date format in Word 2003 mailmerging from excel file.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gerry p - 14 Sep 2005 21:35 GMT

Mailmerging in Word 2003 from an Excel datasource, , the format of the date
goes from 23-Aug-05 in excel file, to 8/23/05 when mailmerged.
Tried everything I know to fix it but it keeps happening and I have to do a
manual change.

Reply to this Message

Graham Mayor - 15 Sep 2005 06:47 GMT

See http://www.gmayor.com/formatting_word_fields.htm and the Excel data
section of http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

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

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

> Mailmerging in Word 2003 from an Excel datasource, , the format of
> the date goes from 23-Aug-05 in excel file, to 8/23/05 when
> mailmerged.
> Tried everything I know to fix it but it keeps happening and I have
> to do a manual change.

Reply to this Message

gerry p - 15 Sep 2005 13:34 GMT

> See http://www.gmayor.com/formatting_word_fields.htm and the Excel data
> section of http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
[quoted text clipped - 6 lines]
>
> Many Thanks Graham - I'm at my Mac just now ( Office 2004) Interestingly the problem dosent happen on the mac. I'll check out the fix this evening when I get into college.

gerry p

Reply to this Message