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 / December 2003

Tip: Looking for answers? Try searching our database.

date mailmerge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
cyril - 01 Dec 2003 12:18 GMT
I am using Office 2002.  If I try to print a letter from
my access application using mailmerge, the date fields do
not always come across in the correct order even though I
have specified dd/MM/yy.  I believe microsoft have a
hotfix for this problem.  How do I obtain it?

Thanks,

Cyril.
Peter Jamieson - 01 Dec 2003 13:30 GMT
Specifying the format in Access and/or Windows Control Panel Regional
Options isn't enough in this case.

You usually need to specify the date format in Word, e.g. if you have a
field such as

{ MERGEFIELD mydate }

try

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

(use Alt-F9 to reveal the underlying field codes).

However, this may not be enough in Word 2002 because of an error in the
OLEDB provider used to get the data from Access. I understand a fix is
available from Microsoft PSS (but possibly not via the web), or you can try
a. creating an Access query that formats the dates how you want (and
returns them as a string to Word)
b. changing the way Word connects to Access to use DDE instead of OLEDB
(but this may create other problems), by checking Word
Tools|Options|General|'Confirm conversions at open', going through the data
source connection process again, and selecting DDE when offered.

--
Peter Jamieson - Word MVP

> I am using Office 2002.  If I try to print a letter from
> my access application using mailmerge, the date fields do
[quoted text clipped - 5 lines]
>
> Cyril.
 
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.