Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge using Access data - date format
G'day!
In Australia we use the date format DD/MM/YYYY. I'm using Access as a data source for a mail merge and in the Access data table it quite happily displays the date the way I want it. When I open up my Word file, the merged dates display in American format MM/DD/YYYY. I'm pretty sure all my other settings are right and using Australian formats. Any idea how I can tweak this to get it to speak Aussie in the merge process? Thanks Karen |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge using Access data - date format
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/cindy...r/MergFram.htm or use the Format() function in a query in Access to force the date into the required format and use that query as the data source for the mail merge. -- 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 "Kazzicles" wrote in message ... G'day! In Australia we use the date format DD/MM/YYYY. I'm using Access as a data source for a mail merge and in the Access data table it quite happily displays the date the way I want it. When I open up my Word file, the merged dates display in American format MM/DD/YYYY. I'm pretty sure all my other settings are right and using Australian formats. Any idea how I can tweak this to get it to speak Aussie in the merge process? Thanks Karen |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date format access to word | Mailmerge | |||
word changes merged access data 'date' format from d/m/y to m/d/y | Mailmerge | |||
How do I get UK date format merging into word from Access? | Mailmerge | |||
date format problem in access 2002 | Tables | |||
Why does the date format change when I mail merge from Access? | Mailmerge |