Exporting Contacts

Status
Not open for further replies.
D

DeweyDL

I have Outlook 2003. When I export my contacts to MSExcel. They are not in Alphabetical Order. If I ADD some contacts in Outlook and then export to excel again - They are not in Alphabetical order. Is there a way to export contacts from Outlook to Excel and have them in Alphabetical Order?
 

Karl Timmermans

Senior Member
Outlook version
Outlook 2013 32 bit
Email Account
POP3


Short answer: No - there is no option to specify output sort order

The term "alphabetical" lies in the eyes of the beholder. For some it would mean by LastName or FullName or FileAs or FirstName & LastName or or or etc and for some it means in ascending order whereas for others it means descending and on it goes

Only takes 2 seconds to sort any worksheet in Excel using any field(s) desired - from Outlook Excel menu
--> Data
--> Sort
--> Specify sort fields and sequence

"
 
D

DeweyDL

I have Outlook 2003. When I export my contacts to MSExcel. They are not in Alphabetical Order. If I ADD some contacts in Outlook and then export to excel again - They are not in Alphabetical order. Is there a way to export contacts from Outlook to Excel and have them in Alphabetical Order?
 
D

DeweyDL

How about simply in the same order that they are in outlook.. They do not export in the same order from Outlook to Excel??
 

Karl Timmermans

Senior Member
Outlook version
Outlook 2013 32 bit
Email Account
POP3


The term "order" is also a relative term - "order" in the UI depends on the "view" in use" any of which can have their own customized "sort order"

The order used by Outlook when exporting items is the sequence in which these were created in the <folder>. If there was an option to specify sort order in Outlook - would involve as many clicks/steps as doing the same thing in Excel using the steps originally listed. The benefit of sorting the resulting file "after the fact" being that it can be changed at will using the same data without having to repeat a given export process to get a desired sequence.

"
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
GregS Exporting contacts Using Outlook 1
J OLADD.FAE Error When Exporting Contacts Using Outlook 6
T exporting contacts names reversed in CSV file Using Outlook 8
R Exporting contacts from 2010 to 2013 Using Outlook 1
B BCM 2010: Exporting Notes to .CSV with Business Contacts? BCM (Business Contact Manager) 3
Commodore Exporting all contacts to VCF files possible? Using Outlook 4
C How to get SMTP out of email address when exporting contacts? Using Outlook 2
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
P Exporting Calendar, Contacts & Tasks from Outlook 2007 to Outlook 2003 Using Outlook 5
C exporting contacts from msn hotmail to outlook Using Outlook 2
M Exporting the Notes field from Outlook Contacts to Excel Using Outlook 1
R Exporting Contacts Error Using Outlook 4
G Exporting Microsoft Outlook Contacts as CSV file Using Outlook 4
N Re: Exporting Outlook contacts via a CSV file into Hotmail Using Outlook 3
B Exporting Contacts in Outlook 2003 Using Outlook 6
S Trouble exporting my Outlook 2003 Contacts file to another computer running Win XP Pro SP3 Using Outlook 3
E Exporting 2003 outlook contacts Using Outlook 1
B Exporting Contacts to a .pst file in Office 2010 Using Outlook 6
S Exporting Contacts to Excel Using Outlook 2
S exporting Contacts to a CSV file 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
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
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
C Security Question - How to prevent users exporting .iaf files Using Outlook 5
P Exporting group members from Outlook address group Using Outlook 11
C extra characters added to email when exporting Using Outlook 2
S Problems with Exporting Data by *.pst Using Outlook 1
S exporting failed deliveries Using Outlook 2
D Need help bulk exporting mailboxes Exchange Server Administration 3
M exporting personal folders from outlook Using Outlook 6
E Exporting all contact information from Outlook. Using Outlook 4
S Exporting wlm into Outlook 2007 Using Outlook 1
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
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
K exporting contact list to and excel worksheet Using Outlook 1
Similar threads


















































Top