[macropod[_2_]]

Hi Dawn,

If you select the mergefields and press Shift-F9, you should see something like {MERGEFIELD MyDate} and {MERGEFIELD MyTime}.

To get the date format you want, you can add a formatting picture switch. For example if you add '\@ "ddd, d MMM yyyy"' to the
field, as in {MERGEFIELD MyDate \@ "dddd, d MMM yyyy"} your date will come out as 'Saturday, 2 August 2008'. You probably want
{MERGEFIELD MyDate \@ "d/MM/yy"}.

Similarly, if you format the time mergefield as {MERGEFIELD MyTime \@ "HH:mmAM/PM"} you should get the results you're after.

--
Cheers
macropod
[MVP - Microsoft Word]


"dawnjlane" wrote in message ...

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

[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

[Doug Robbins - Word MVP]

If that doesn't work, use the Format() function in a Query in Access to
convert the date to text in the format that you want it.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"macropod" wrote in message
...
Hi Dawn,

If you select the mergefields and press Shift-F9, you should see something
like {MERGEFIELD MyDate} and {MERGEFIELD MyTime}.

To get the date format you want, you can add a formatting picture switch.
For example if you add '\@ "ddd, d MMM yyyy"' to the field, as in
{MERGEFIELD MyDate \@ "dddd, d MMM yyyy"} your date will come out as
'Saturday, 2 August 2008'. You probably want {MERGEFIELD MyDate \@
"d/MM/yy"}.

Similarly, if you format the time mergefield as {MERGEFIELD MyTime \@
"HH:mmAM/PM"} you should get the results you're after.

--
Cheers
macropod
[MVP - Microsoft Word]


"dawnjlane" wrote in message
...

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

[dawnjlane[_2_]]

Thanks - worked a treat.

Dawn

--
dawnjlane[/i][/color]
[/i][/color]




--
dawnjlane