[dawnjlane]

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