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.

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


--

Graham Mayor - Word MVP

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


gerry p wrote:
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.

"Graham Mayor" wrote:

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


--

Graham Mayor - Word MVP

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


gerry p wrote:
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.


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