Merge mailing using Access

[Aietoe]

Hi!

Using Office 97, i do a merge mailing in Word using data that comes from a table in Access.
One of the field is a date with the following format in Access: YYYY-MM-DD
In Word, i convert the format using the following formula:{CHAMPFUSION DATE \@ " JJJJ, J MMMM, AAAA"}} .It works fine and i get a date like this: mardi, 10 octobre, 2000 .
My problem is that i have some documents that must be printed in English.
Would somebody know what parameter must be changed in Word to have my date converted in an english format( Tuesday, 10 October, 2000 )

Thanks

Aietoe

 

[Dreamboat]

Aietoe, it is VERY much easier to do this in Access and not Word. However, I believe it would be:

{CHAMPFUSION DATE \@ "dddd, mmmm d, yyyy"}}

http://www.TheWordExpert.com

 

[Aietoe]

Hi Dreamboat,

I tried your solution, but it doesn't work.

Thanks anyway

Aietoe