US / English date format mailmerge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bento72 - 07 Feb 2006 12:56 GMT

Hi, been trying to merge with Access and the dates come across in US format.
I understand the stuff about not bringing formatting across and have tried
the format switches but although they change the way the date is displayed
(i.e. 2/1/06, 2nd January 2006, Monday, 2nd Jan and so on...) the recognition
of which figure is day and month etc doesn't work. I have ensured that the
dates are correct in Access by using long date (e.g. 1st February 2006) but
just cannot get them to read the same in Word once merged. What else can I
try ?

Reply to this Message

Peter Jamieson - 07 Feb 2006 13:57 GMT

The following article may be worth a look:

"Month and day are not displayed in the order that you expect in a mail
merge document linked to an external data source in Word 2002"

at

http://support.microsoft.com/kb/327579/

Peter Jamieson

> Hi, been trying to merge with Access and the dates come across in US
> format.
[quoted text clipped - 9 lines]
> I
> try ?

Reply to this Message