 |
 | 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 / June 2007Email Merge - Number Format vs Text
It seems to me that in previous versions of office - if I pasted special values into my Excel merge data base it would flow through to the email merge - now I have to tediously type in $ and commas in text formatting in order to get the numbers to flow through properly. Otherwise it would just be 155553823.35 Does anyone know a better way?? I still want the commas represented in the emails. Thanks! It sounds as if you've probably upgraded from Word 97 or 2000. In Word 2007 you need to switch back to the DDE connection method - check Microsoft Office Button|Word Options|Advanced|General|"Confirm File format conversion upon open" then go through the process of opening your data source again. If you have non-ANSI Unicode characters in your data, DDE won't return them. Also, no method currently lets you use more than 255 columns in an Excel sheet, and with DDE the number may be more restricted in Word 2007. Peter Jamieson > It seems to me that in previous versions of office - if I pasted special > values into my Excel merge data base it would flow through to the email [quoted text clipped - 5 lines] > Does anyone know a better way?? I still want the commas represented in the > emails. 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.