 |
 | 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 / August 2006Mail Merge Dates
Hi I'm having some problems with Mail merge and date formats. I have a spreadsheet which contains some dates in the dd/mm/yyyy date format eg Start_date Finish_Date 1/1/2005 30/6/2007 When I insert these fields in a mail merge document, I get them in the mm/dd/yyyy date format. My question is, Is there a way to change the format? coyotem78 See the "Dates: day/month reversed" item under the "Connection methods" topic of the "Mail merge in Word 2002" section of fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindymeister/MergFram.htm  SignaturePlease respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP > Hi > [quoted text clipped - 11 lines] > > coyotem78 I also have a problem with dates. I have them in an excel spreadsheet the English way 4/8/06 for 4th August but when merged it is changing it to Amercian 8/04/06 how do I change it back > Hi > [quoted text clipped - 11 lines] > > coyotem78 See the "Dates: day/month reversed" item under the "Connection methods" topic of the "Mail merge in Word 2002" section of fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindymeister/MergFram.htm SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP >I also have a problem with dates. I have them in an excel spreadsheet the > English way 4/8/06 for 4th August but when merged it is changing it to [quoted text clipped - 15 lines] >> >> coyotem78 |
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.