![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
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. -- Deb H. |
Ads |
#2
|
|||
|
|||
![]()
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 -- __________________________________________________ ___________ 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 "Deb" wrote in message ... 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. -- Deb H. |
#3
|
|||
|
|||
![]()
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 -- Deb H. "Karl Timmermans" wrote: 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 -- __________________________________________________ ___________ 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 "Deb" wrote in message ... 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. -- Deb H. |
#4
|
|||
|
|||
![]()
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 -- __________________________________________________ ___________ 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 "Deb" wrote in message ... 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 -- Deb H. "Karl Timmermans" wrote: 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 -- __________________________________________________ ___________ 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 "Deb" wrote in message ... 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. -- Deb H. |
#5
|
|||
|
|||
![]()
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/legaul...4/08/4502.aspx
-- Sue 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 "Karl Timmermans" wrote in message ... 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 -- __________________________________________________ ___________ 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 "Deb" wrote in message ... 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 -- Deb H. "Karl Timmermans" wrote: 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 -- __________________________________________________ ___________ 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 "Deb" wrote in message ... 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. -- Deb H. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
shortcut for notes field | BorisS | Outlook - Using Contacts | 0 | April 10th 06 03:18 PM |
Contacts: notes field | toneas7 | Outlook - Using Contacts | 1 | April 5th 06 11:17 AM |
"Notes" field on contact form | kleivakat | Outlook - Using Contacts | 0 | February 20th 06 03:58 PM |
How do I export contact to .xls and retain the entire notes field | skar3000 | Outlook - Using Contacts | 0 | February 1st 06 05:01 PM |
Populate Company field from Contact field in custom task form | Sue Mosher [MVP-Outlook] | Outlook - Using Forms | 0 | January 20th 06 08:37 PM |