how do i stop mailmerge date format mm showing as 00

[Brian M]

On merging from excel and access the date fields are changed from UK to US
format. i have altered the field codes using \@ "dd/MM/yy" the day and year
changed fine but the month is displayed as 00. how can i get the date to stop
converting to US format or show in UK format DD/MM/YY?

 

[Doug Robbins - Word MVP]

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm


--
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