 |
 | 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 / January 2008Losing Date Format Upon Mailmerge
Good day, Using Excel/Word 2007 I have 3 date columns in Excel sheet, formatted as dd/mm/yyyy. Upon mailmerge, one column retains this date format into the Word doc. However the other two date columns appear as gregorian format - I think that's the name? e.g. 1/18/2008 in Excel sheet, appears 39455 in the Word doc. I have double-checked the format in the Excel dates, without luck. Really appreciate it - From the Pizza button inWord 2007, select Word Options and then go to the Advanced tab > General 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 <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Good day, > [quoted text clipped - 6 lines] > 39455 in the Word doc. I have double-checked the format in the Excel > dates, without luck. Really appreciate it - Wow! thank you Graham. It worked like a charm! Note: I had to re-start (refresh) mailmerge and refresh recipient list, where I selected DDE method. p.s. - I wonder why one column of dates was merging as shown in Excel, while two other columns were not. 'as though some fields were automatically in DDE, and some were not. just a curiosity. Really appreciated your help. > From the Pizza button inWord 2007, select Word Options and then go to the > Advanced tab > General and check the box against the "Confirm conversions at [quoted text clipped - 12 lines] > > 39455 in the Word doc. I have double-checked the format in the Excel > > dates, without luck. Really appreciate it - DDE is no longer the default method of data attachment to a merge document and so no formatting is brought over - only the underlying data. DDE can still be used, as you have found, but it is a bit flaky. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Wow! thank you Graham. It worked like a charm! > [quoted text clipped - 31 lines] >>> 39455 in the Word doc. I have double-checked the format in the >>> Excel dates, without luck. Really appreciate it - > p.s. - I wonder why one column of dates was merging as shown in Excel, > while two other columns were not. 'as though some fields were > automatically > in DDE, and some were not. just a curiosity. See http://tips.pjmsn.me.uk/t0003.htm SignaturePeter Jamieson http://tips.pjmsn.me.uk > Wow! thank you Graham. It worked like a charm! > [quoted text clipped - 26 lines] >> > 39455 in the Word doc. I have double-checked the format in the Excel >> > dates, without luck. Really appreciate it - |
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.