 |
 | 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 / Outlook / Contacts / August 2006How can I export Notes field from Contact records in one field?
On exporting contact records with Notes, I find that the export creates a separate cell for every line in the Notes field instead of one cell for the entire Notes field. Is there any way to keep all of the Notes data together in one field? This is a biggy for me. Any advice is very welcome! Thanks.  SignatureDeb H. Version of Outlook? Version of Excel? (assume you're referring to Excel since you used the term "cell"). Not a behaviour we've ever seen using Outlook. Actually just tried this again before responding just to be sure and multi-line note fields were exported to a single column using CSV, XLS and .MDB as output formats using O'2003's export wizard. Ran this test using both hard and soft returns in the Notes field. Outlook's import/export wizard has remained pretty much the same between O'2000-O'2003 (if not actually remaining absolutely identical). What program are you using to read the resulting data file - an MS product or some other program? Not all programs are "multi-line" aware but that would typically result in multiple lines per contact versus multiple "cells". Karl Signature_____________________________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2003" http://www.contactgenie.com > On exporting contact records with Notes, I find that the export creates a > separate cell for every line in the Notes field instead of one cell for [quoted text clipped - 4 lines] > > Any advice is very welcome! Thanks. Yes, Outlook, Excel 2003 (sorry). I think you solved the problem. I am importing it into ACT! which requires a .txt file. However, if I export it as a csv file instead of a txt file, it works fine. There is one other issue you might have a solution for. Is there a way to strip out the carriage return symbol (I think that's what it is) before saving it as a txt file? I don't really want to import it with that in it but I don't know how to replace it with a space. Is there a way? Thank you very much for your advice. You hit on the problem. Now I just need a way to replace the funky symbol. Deb SignatureDeb H. > Version of Outlook? Version of Excel? (assume you're referring to Excel > since you used the term "cell"). [quoted text clipped - 21 lines] > > > > Any advice is very welcome! Thanks. Been far too long since I've looked at the Act data structures to remember what is imported or exported in terms of street address line fields. Yes it is the CR (Hex value "0D" / decimal value 13 to be exact) that shows up as the special char. For a CSV (or any text) file - you'd need a text editor that has Hex search & replace capabilities but you'd want to make sure that you only do it for the specific column - not exactly a straightforward approach in most cases. Have seen a number of Excel Add-ins that provide enhanced Find & Replace capabilities but not familiar with any of them directly or if selective special characters were supported. Perhaps someone else in the Excel newsgroup can be of more help to you in that regard or alternatively search Google for one of those Excel addins. (Reason for Excel would be to strip the character in a specific column only and then saving it as a CSV file for use in Act) Karl Signature_____________________________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2003" http://www.contactgenie.com > Yes, Outlook, Excel 2003 (sorry). I think you solved the problem. I am > importing it into ACT! which requires a .txt file. However, if I export [quoted text clipped - 42 lines] >> > >> > Any advice is very welcome! Thanks. If some of the fields are multi-line, see Eric Legault's handy tip for an Excel formula to break up the lines -- http://blogs.officezealot.com/legault/archive/2005/04/08/4502.aspx SignatureSue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx > Been far too long since I've looked at the Act data structures to remember > what is imported or exported in terms of street address line fields. [quoted text clipped - 60 lines] >>> > >>> > Any advice is very welcome! 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
|
©2009 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.