Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get UK date format merging into word from Access?
Am using XP, Office 2003. Database in Access with UK date format entering ok
(dd/mm/yy). Mail merging into Word document always transfers date format to US! (mm/dd/yy)! Have been altering dates manually for ages, but am getting tired of it! Any suggestions will be greatly received. I think I have tried everything! |
#2
|
|||
|
|||
Gavvers,
Try adding a date picture switch to the merge field {MERGEFIELD "Your mergefield name" \@ "dd/MM/yy"} -- Greg Maxey/Word MVP A Peer in Peer to Peer Support http://gregmaxey.mvps.org/word_tips.htm Gavvers wrote: Am using XP, Office 2003. Database in Access with UK date format entering ok (dd/mm/yy). Mail merging into Word document always transfers date format to US! (mm/dd/yy)! Have been altering dates manually for ages, but am getting tired of it! Any suggestions will be greatly received. I think I have tried everything! |
#3
|
|||
|
|||
Gavvers,
Better yet, 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=AD/ci...r/MergFram.htm |
#4
|
|||
|
|||
Gavvers,
Better yet, 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=AD/ci...r/MergFram.htm |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Excel data for merging in Word | Mailmerge | |||
Mailmerge in Word, date format in merged doc | Mailmerge | |||
macro in word | Microsoft Word Help | |||
Date issue merging from Excel field in Date format to Word | Mailmerge | |||
Mail Merge - Date Format | Microsoft Word Help |