 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / December 2007Mail merge date field formats in word
I am trying to print a date in a word merged document with a UK date format (DD/MM/YYYY). However, the date is displayed in a US format (MM/DD/YYYY). I have checked the regional settings on the PC/laptop and have looked at the date formats in the Access database where the merge data is stored, but to no avail. Any advice greatly appreciated... Right click on the field in word and Edit the field code to look something like { "MERGEFIELD "YourDateFieldName" \@"dd,MM,yyyy"} be careful to use caps where necessary  SignatureHope this helps :-) > I am trying to print a date in a word merged document with a UK date format > (DD/MM/YYYY). However, the date is displayed in a US format (MM/DD/YYYY). [quoted text clipped - 4 lines] > > Any advice greatly appreciated... Exactly like { MERGEFIELD YourDateFieldName \@ "dd/MM/yyyy"} would give the requested format! Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Right click on the field in word and Edit the field code to look > something like [quoted text clipped - 10 lines] >> >> Any advice greatly appreciated... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.