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 / April 2005

Tip: Looking for answers? Try searching our database.

Mailmerge changing date format

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Diane@Adlam - 21 Apr 2005 12:11 GMT
Mailmerge keeps changing date format to American format.  I can't get it to
keep to English. ie: 26/01/2005.  

Version 5.1.2600 Service Pack 2 Build 2600.  Microsoft Windows XP Professional
Peter Jamieson - 21 Apr 2005 16:35 GMT
Depending on your data source, you either have to:
a. use DDE to get your data from Access or Excel. If it's Word 2002 or
later, check Word Tools|Options|General|"Confirm conversion at open", go
through the ocnnection processagain and select the DDE option when offered.
It only works for Excel or Access data sources and requires Excel or Access
on your machine.
b. use date formatting switches in Word, e.g. change

{ MERGEFIELD mydate }

to

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

If that still doesn't work (in particular, if it works for non-ambiguous
dates where the day number cannot be mistaken for a month, but not
otherwise) it is because of a fault in the provider/driver that gets the
data. You may be able to get a patch from Microsoft Customer Services (I
don't know of one that can be downloaded).

Peter Jamieson

> Mailmerge keeps changing date format to American format.  I can't get it
> to
> keep to English. ie: 26/01/2005.
>
> Version 5.1.2600 Service Pack 2 Build 2600.  Microsoft Windows XP
> Professional
 
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.