Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2007

Tip: Looking for answers? Try searching our database.

date format changing in mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mixers - 07 Jun 2007 16:23 GMT
When mail merging a word document through an Access database, the date format
field changes from UK to US. How do I prevent this?
Peter Jamieson - 07 Jun 2007 16:48 GMT
It may depend on the precise version of Word, but you can try
a. add a "format switch" to each date MERGEFIELD field in Word. e.g. use
Alt-F9 to view the fields, in the mail merge main document, then change

{ MERGEFIELD mydate }

to

{ MERGEFIELD mydate \@"DD/MM/YYYY" }

Test with ambiguous dates, i.e. where the day number is 1 to 12.
b. if you are using Word XP/2003, change back to the old DDE connection
method (check Word Tools|Options|General|Confirm conversion at open, then go
through the connection process again. Word has to start Access if it's not
already going, you lose non-ANSI characters in text fields, and thetreatment
of other field types, particularly memo fields, may be different.

Peter Jamieosn

> When mail merging a word document through an Access database, the date
> format
> field changes from UK to US. How do I prevent this?
 
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.