A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How can I export Notes field from Contact records in one field?



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old June 15th 06, 02:21 AM posted to microsoft.public.outlook.contacts
Deb
external usenet poster
 
Posts: 46
Default How 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.
--
Deb H.
Ads
  #2  
Old June 15th 06, 03:49 AM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 789
Default How can I export Notes field from Contact records in one field?

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  
Old June 22nd 06, 04:36 PM posted to microsoft.public.outlook.contacts
Deb
external usenet poster
 
Posts: 46
Default How can I export Notes field from Contact records in one field

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  
Old June 22nd 06, 09:36 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 789
Default How can I export Notes field from Contact records in one field

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  
Old August 28th 06, 09:12 PM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default How can I export Notes field from Contact records in one field

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
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


All times are GMT +1. The time now is 08:39 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.