mailmerge changes date to American format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Linda - 14 Jan 2004 10:41 GMT

My regional settings are correctly set to UK date format. I'm merging from an Access 2002 database query into a mailmerge document and the dates change into American format. There doesn't appear to be any way to format the date field within the mail merge. Any ideas that don't involve programming!

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 14 Jan 2004 11:48 GMT

Hi Linda,

See the "Dates: day/month reversed" item under the "Connection Methods"
section of the "Mail merge in Word 2002" topic on fellow MVP CIndy Meister's
website at http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

> My regional settings are correctly set to UK date format. I'm merging
> from an Access 2002 database query into a mailmerge document and the dates
> change into American format. There doesn't appear to be any way to format
> the date field within the mail merge. Any ideas that don't involve
> programming!

Reply to this Message