 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / February 2006change date layout mergefield
Hi, How can I change a date mergefield so it shows dd-mm-yyyy now by default? it shows mm-dd-yyyy I tried adding \@ "dd-mm-yyyy" to the mergefield options but the month shows 00 kind regards christophe  Signature\|||/ (o o) ----ooO-(_)-Ooo------------- What you should have is \@ "dd-MM-yyyy" Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hi, > [quoted text clipped - 8 lines] > kind regards > christophe Graham, It doesn't work very well. the date starts with the month ?! I've checked the table (foxpro table) There it is ok. I've changed in word the mergefieldcoding to MM-dd-yyyy and then it shows correct. but the first user who will see this coding He will probably ask if everthing is ok with me ;-) regards christophe Signature\|||/ (o o) ----ooO-(_)-Ooo------------- > What you should have is > \@ "dd-MM-yyyy" [quoted text clipped - 11 lines] >> kind regards >> christophe Now you have introduced a different issue :( See http://support.microsoft.com/kb/327579/ Also From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the date as you have it formatted in the table. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham, > [quoted text clipped - 33 lines] >>> kind regards >>> christophe Ok, let's get the Hotfix thanks a lot christophe Signature\|||/ (o o) ----ooO-(_)-Ooo------------- > Now you have introduced a different issue :( > See http://support.microsoft.com/kb/327579/ [quoted text clipped - 43 lines] >>>> kind regards >>>> christophe |
Reply to this Message |
 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.