Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
dawnjlane dawnjlane is offline
external usenet poster
 
Posts: 1
Default Mailmerge from Access - incorrect date/time format


Hi Everyone

I am having problems with mail merge between Access and Word with date
and time formats changing.

I use Office 2007 and the date in Access is set to short date ie
02/08/08 and time also to short time ie 12:00PM. When I do a mail merge
into a Word template the dates are transposing into American long date
ie 08/02/2008 and time as 12:00:00 PM.

I have checked the date and time settings in Access, Word and on the
computer itself and all are set to UK English.

I am presently having to do a find and replace for all the entries
which is quite tiresome as there are 3 x different date entries and 1
time entry.

Any one come across this before and how did you solve it?

Dawn




--
dawnjlane
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access Query to mailmerge US Date Big Mac Mailmerge 5 January 2nd 08 06:01 PM
Format Date and Time to show Military Time AlanFD Microsoft Word Help 2 September 22nd 06 10:44 PM
Date and time format Rjoines Microsoft Word Help 1 May 11th 06 05:32 AM
Inserting date/time in certain format? StargateFan New Users 15 February 13th 05 07:15 PM
incorrect date format in mail merge mark P Mailmerge 1 December 14th 04 08:29 AM


All times are GMT +1. The time now is 05:57 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"