Mail Merge Date Formats

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adam C - 24 Aug 2004 11:37 GMT

Help!

I've created a merge document in word, which takes it's data from a MS
access query. the data in the Access query is held in UK format (ie date
shows as 9/07/04- 9th July 2004) when merge runs, date shows in resultant
document as 7/9/2004, in US format, when you add switches it displays the
date as September 7th 2004 not 9th July 2004.

I've checked all teh settings in control panel, and my system is set up for
UK English.

Any assistance would be greatly appreciated.

Thanks

Adam

Reply to this Message

Cindy M -WordMVP- - 24 Aug 2004 16:41 GMT

Hi =?Utf-8?B?QWRhbSBD?=,

What you're describing is a common problem in the original release of Word
2002. Later service packs should have fixed this problem.

If, for some reason, installing a service pack is not an option for you, then
you'll need to connect to the Access data using something other than OLE DB.
You'll find instructions for selecting the connection method in the Word 2002
section of my website's mail merge FAQ.

> I've created a merge document in word, which takes it's data from a MS
> access query. the data in the Access query is held in UK format (ie date
[quoted text clipped - 4 lines]
> I've checked all teh settings in control panel, and my system is set up for
> UK English.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply to this Message

Rate this thread: