 |
 | 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 / March 2007mailmerge date conversion
I have a mailmerge document with excel source data. I have date fields in excel, but when I merge it reverts to the original serial number. How do I convert it back to display the desired date format. Please Help. Thanks In response to your three(?) questions - 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 data 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 <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I have a mailmerge document with excel source data. I have date > fields in excel, but when I merge it reverts to the original serial > number. How do I convert it back to display the desired date format. > Please Help. Thanks Thank you so much for that! That's so much easier than toggling the fields which doesn't work for my dates. > In response to your three(?) questions - From the Tools menu in Word, select > Options and then go to the General tab and check the box against the [quoted text clipped - 7 lines] > > number. How do I convert it back to display the desired date format. > > Please Help. Thanks Hope you could help me again. How Do you align currency figures so that the values are right justified or all decimal points aligned together? > In response to your three(?) questions - From the Tools menu in Word, select > Options and then go to the General tab and check the box against the [quoted text clipped - 7 lines] > > number. How do I convert it back to display the desired date format. > > Please Help. Thanks See the answer to your other post! There is no need to post the same thing in several places. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hope you could help me again. How Do you align currency figures so > that the values are right justified or all decimal points aligned [quoted text clipped - 19 lines] >>> number. How do I convert it back to display the desired date >>> format. Please Help. Thanks |
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.