If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mail Merge Date Formats
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 |
#2
|
|||
|
|||
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 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. 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 :-) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge - Date Format | JWF | General Discussion | 3 | December 7th, 2004 01:13 PM |
Mail Merge by E-Mail | Jennifer | General Discussion | 1 | June 22nd, 2004 12:18 PM |
Calendar Mail Merge?? | JMax | General Discussion | 1 | June 16th, 2004 12:51 AM |
HELP!!! Using Mail Merge Wizard / Access v2002 | [email protected] | Mailmerge | 1 | May 21st, 2004 08:51 AM |
Merge to Fax with SBS/Exchange? | Tom | Mailmerge | 3 | May 18th, 2004 11:22 PM |