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.

Date mail merge field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
KL - 12 Apr 2005 11:01 GMT
I use mail-merge to send reminders to a member base.  One of the fields is
the date their renewal is due, and for some reason, it always shows in the
wrong format i.e. as mm/dd/yy instead of dd/mm/yy  It shows as correct in the
database and I can't find a way or permanently correcting in the word
document.  I would be grateful if anyone could point me in the right
direction.  I have been reading in Microsoft Help about switches and field
codes, but unsuccesful in getting them to work!

many thanks

K
Peter Jamieson - 12 Apr 2005 11:51 GMT
Let's suppose your date field is called mydate. If you open your Mail Merge
Main Document, press Alt-F9 to see the underlying field codes, your field
should look something like

{ MERGEFIELD myfield }

(there may also be \*Mergeformat at the end but ignore that for now). Try
changing that to

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

and doing the merge again. If that works, fine. If not, you will probably
notice that the month and day are correct in the cases where the day number
is greater than 12 and cannot be mistaken for a month. In that case you
/may/ get the result you need by changing the way Word connects to Access
(if you are using Word 2002/2003), try checking Word
Tools|Options|General|"Confirm conversion at open", going through the
connection process again, and choosing DDE when offered. There are other
possibilities but that should do for starters.

Peter Jamieson

>I use mail-merge to send reminders to a member base.  One of the fields is
> the date their renewal is due, and for some reason, it always shows in the
[quoted text clipped - 8 lines]
>
> K

Rate this thread:






 
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.