Exporting the Notes field from Outlook Contacts to Excel

Status
Not open for further replies.
M

Madeline May

I am using Excel to make changes to my contacts by exporting them and then importing back into Outlook once the changes have been made. I am running into an issue with the " Notes" field in my contacts. The character length that exports into Excel seems limited. Is there a way to export the entire Notes field into Excel (some even contain logos)? Or would another file version, such as Access, work better? Any advice would help!
 

Karl Timmermans

Senior Member
Outlook version
Outlook 2013 32 bit
Email Account
POP3
Notes <Text> file export specs (none export images or linked files of any kind - this does not include formatting which would require the field to be exported in RTF / HTML format etc using some other export process):

CSV file type - full text

MS Access - full text (exported as a memo field - max length 64K)

MS Excel - 256 characters

If you want to use Excel - recommendation would be to always export to a CSV file and then open that file in Excel instead of exporting to an .xls file. That way you avoid any Excel related idiosyncracies (there are a few). If you import the data back - save as a CSV file or make very sure that the " named range" is adjusted accordingly if you've added records etc.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
B BCM 2010: Exporting Notes to .CSV with Business Contacts? BCM (Business Contact Manager) 3
M Exporting history notes from Outlook 2003 Using Outlook 1
GregS Exporting contacts Using Outlook 1
J OLADD.FAE Error When Exporting Contacts Using Outlook 6
R Exporting recovered Deleted Items outside the Inbox Using Outlook 1
N Exporting IM Address field Using Outlook 2
E Exporting email (.pst) Using Outlook 8
T exporting contacts names reversed in CSV file Using Outlook 8
R Exporting Excel data to Outlook 2016 Calendar Outlook VBA and Custom Forms 20
D EXPORTING MS EXCHANGE EMAILS to another platform Exchange Server Administration 10
R Exporting contacts from 2010 to 2013 Using Outlook 1
Connie Boyer Exporting Outlook calendar/find next repeating meeting Using Outlook 3
A Exporting email in outlook 2013 with Office 365 Using Outlook 1
Diane Poremsky Fix the Outlook Folder Type after Exporting an IMAP Account New Slipstick.com Articles 0
V Unknown error when exporting to a PST Outlook Wishlist 2
V Exporting RSS Feed to OPML file Using Outlook 8
D Reoccuring appointment issues when exporting Calendar to Excel Using Outlook 3
Commodore Exporting all contacts to VCF files possible? Using Outlook 4
C Security Question - How to prevent users exporting .iaf files Using Outlook 5
C How to get SMTP out of email address when exporting contacts? Using Outlook 2
P Exporting group members from Outlook address group Using Outlook 11
M Error Messages when exporting Outlook 2010 Contacts to a CSV (DOS) or Excel Using Outlook 2
R Exporting and importing contacts in Outlook 2007 Using Outlook 1
C extra characters added to email when exporting Using Outlook 2
P Exporting Calendar, Contacts & Tasks from Outlook 2007 to Outlook 2003 Using Outlook 5
S Problems with Exporting Data by *.pst Using Outlook 1
C exporting contacts from msn hotmail to outlook Using Outlook 2
S exporting failed deliveries Using Outlook 2
D Need help bulk exporting mailboxes Exchange Server Administration 3
D Exporting Contacts Using Outlook 5
R Exporting Contacts Error Using Outlook 4
M exporting personal folders from outlook Using Outlook 6
E Exporting all contact information from Outlook. Using Outlook 4
G Exporting Microsoft Outlook Contacts as CSV file Using Outlook 4
S Exporting wlm into Outlook 2007 Using Outlook 1
N Re: Exporting Outlook contacts via a CSV file into Hotmail Using Outlook 3
J Exporting Contact Groups in OL 2010 Using Outlook 4
K Exporting to PST Outlook 2010 Exchange Server Administration 1
R Problem exporting Exchange 2010 selsigned certificate Exchange Server Administration 3
R Exporting outlook 2010 tasks to excel Using Outlook 2
P exporting and importing email accounts Outlook 2010 Using Outlook 3
B Exporting Contacts in Outlook 2003 Using Outlook 6
N Re: Exporting Outlook History Using Outlook 4
F Oulook 2007 emails exporting Using Outlook 3
P Exporting into vCard (Outlook 2010) Using Outlook 3
S Trouble exporting my Outlook 2003 Contacts file to another computer running Win XP Pro SP3 Using Outlook 3
K exporting contact list to and excel worksheet Using Outlook 1
S Exporting Exchange 2003 Schedule+FreeBusy Exchange Server Administration 2
D Exporting Contact with a specific category Using Outlook 1
T missing email address when exporting mails from Window Live Mail to Outlook Using Outlook 1
Similar threads


















































Top