Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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... |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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 -- Hope this helps :-) "Slim" wrote: 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... |
#3
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Exactly like { MERGEFIELD YourDateFieldName \@ "dd/MM/yyyy"} would give the
requested format! -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Big Mac wrote: 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 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... |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mail merge with Word 2003 and SQL 2005 on a date and time field. | Mailmerge | |||
How can I maintain Excel date formats in a mail merge? | Mailmerge | |||
Mail Merge Date field | Mailmerge | |||
Date mail merge field | Mailmerge | |||
How do I filter a Dbase date field in a word mail merge documnet? | Mailmerge |