Please Help - Mail merge changes format of field when merged

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NeetaV - 26 Jan 2005 02:15 GMT

Just updated to Word 2003. When I merge with database held in Excel 2003
field with date changes from Australian format I typed in to American format,
eg 31/12/2004 changes in merged field to 12/31/2004. I've made sure my
settings are all set to use Australian everything but it still changes in the
process of merging. How do I fix this problem. I know that I can manually
change after fields have been merged but it is a real pain, I've never had
this problem in the previous versions of Word I have used. Any help would be
greatly appreciated. Thanks.

Reply to this Message

Graham Mayor - 26 Jan 2005 05:57 GMT

See 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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Just updated to Word 2003. When I merge with database held in Excel
> 2003 field with date changes from Australian format I typed in to
[quoted text clipped - 5 lines]
> previous versions of Word I have used. Any help would be greatly
> appreciated. Thanks.

Reply to this Message

NeetaV - 29 Jan 2005 01:57 GMT

Thank you so much for your help.

> See the Excel data section of
> http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
[quoted text clipped - 8 lines]
> > previous versions of Word I have used. Any help would be greatly
> > appreciated. Thanks.

Reply to this Message