Outlook 2011 Contact Import from CSV with Notes containing new lines / cr / lf

Posted by Paul Hargreaves on Super User See other posts from Super User or by Paul Hargreaves
Published on 2011-11-27T09:03:42Z Indexed on 2011/11/27 9:55 UTC
Read the original article Hit count: 5801

Filed under:

csv

|

outlook-2011

I'm trying to import several thousand contacts into Outlook 2011 for Mac. Everything is working well except the Notes field as I cannot figure out how to get new lines / carriage returns into it.

There is no documentation for the exact format that Outlook supports. After searching the web and experimenting I have tried:

Creating a single contact in Outlook with Notes containing several lines of text. I then export the contact to a csv, deleting the contact in Outlook, then re-import. All lines in Notes merge together :-/
Following tips I found such as containing new lines around quotes. e.g. http://creativyst.com/Doc/Articles/CSV/CSV01.htm (search for line-break)
Switching the CSV format from DOS to Unix, experimenting using manually injected ctrl-characters such as ^M etc.

I would include an example export/import but unfortunately the the new breaks included do not work well in a SU code block.

© Super User or respective owner

Related posts about csv

DBD::CSV: How can I generate different behavior with the two f_ext-options ".csv" and ".csv/r"?

as seen on Stack Overflow - Search for 'Stack Overflow'
This is from the DBD::File-documentation: f_ext This attribute is used for setting the file extension where (CSV) files are opened. There are several possibilities. DBI:CSV:f_dir=data;f_ext=.csv In this case, DBD::File will open only table.csv if both table.csv and table exist… >>> More
SUPER CSV write bean to CSV.

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is my class, public class FreebasePeopleResults { public String intendedSearch; public String weight; public Double heightMeters; public Integer age; public String type; public String parents; public String profession; public String alias; public String children; public String siblings; public… >>> More
export to csv using fastercsv and CSV::Writer (Ruby on Rails)

as seen on Stack Overflow - Search for 'Stack Overflow'
What am I trying to do: export data to csv. I have a form which allows user to select the format (from a drop down menu). So based on the selection of the format the ouput is displayed using a ajax call. Works fine for html but when I select the format as csv I don't see any pop up on the screen… >>> More
How can i make changes to this file Encoding?

as seen on Super User - Search for 'Super User'
I have these 3 files 21/08/2014 07:15 PM 122 Tw2AWK.csv 21/08/2014 07:15 PM 125 Tw2Notepad.csv 21/08/2014 07:15 PM 119 Tw2REPL.csv C:\myfilesfile Tw2AWK.csv TwREPL.csv Tw2Notepad.csv Tw2AWK.csv; UTF-8 Unicode text, with CRLF line terminators Tw2REPL… >>> More
Unix sort keys cause performance problems

as seen on Super User - Search for 'Super User'
My data: It's a 71 MB file with 1.5 million rows. It has 6 fields All six fields combine to form a unique key - so that's what I need to sort on. Sort statement: sort -t ',' -k1,1 -k2,2 -k3,3 -k4,4 -k5,5 -k6,6 -o output.csv input.csv The problem: If I sort without keys, it takes 30 seconds… >>> More

Related posts about outlook-2011

Outlook 2011 Contact Import from CSV with Notes containing new lines / cr / lf

as seen on Super User - Search for 'Super User'
I'm trying to import several thousand contacts into Outlook 2011 for Mac. Everything is working well except the Notes field as I cannot figure out how to get new lines / carriage returns into it. There is no documentation for the exact format that Outlook supports. After searching the web and experimenting… >>> More
Tasks not appearing in Mac Outlook 2011

as seen on Super User - Search for 'Super User'
My current workplace uses Macs and my old workplaces used Windows. In my old workplaces I heavily used Outlook's Task functionality to manage my workload. I understand that the Task functionality in Outlook 2011 for Mac is heavily limited so I was very pleased to find this useful "how-to" on making… >>> More
Embedded Spotlight does not function in Outlook 2011

as seen on Super User - Search for 'Super User'
I have a rather strange problem. I manage a network of about 35 Mac, and we all recently switched from Mail.app to Outlook 2011 (Please don't debate this, I've already had this conversation ad nauseum) We are using network home directories (NHD) server from a Windows file server over the SMB protocol… >>> More
tagging all email addresses from my mac microsoft outlook 2011

as seen on Super User - Search for 'Super User'
I have been using Outlook for Mac 2011 for last 2 years. Now I want to list out all the people in my email correspondences (sent and inbox) and send them one email. Where can I find the database of everyone's email address in my Mac? The mail will have to have email addresses one after another like… >>> More
Move Emails Easily Using Search - Outlook 2011 Feature on the MAC for Outlook 2010 Windows

as seen on Super User - Search for 'Super User'
My main email client is Outlook 2010 for Windows 7. I also have a Mac but I do not use it that much however on the MAC you have Outlook 2011. In my Outlook 2010 for Windows 7, I have many many folders. There is one feature I would like to know if it is available or something similar which is on Outlook… >>> More