Exporting contacts from outlook

When I export my contacts to a .csv file from Outlook, the email addresses show up as exchange paths rather than the email address displayed in my contacts.  For example, it will show "'/o=YCorpMail/ou=First Administrative Group/cn=Recipients...." rather than the actual email address.  Is there a way to change this when it exports?
Who is Participating?
digitapConnect With a Mentor Commented:
I'm not sure if this is what you're looking for, but:

Your best bet, at this point, is to put all the addresses into name@domain.com format (which can be prohibitively time consuming if your contacts list is long) or use the following workaround to create a text file that you can import:

   1. In Outlook, go to Contacts.
   2. Click the Contacts folder that contains the contacts you want to export.
   3. Under Current View, click Phone List, and then click Customize Current View.
   4. In the Customize View dialog box, click Fields. In the Show Fields dialog box, remove and add fields as necessary so that only Full Name and E-mail fields are listed in the box on the right. Click OK, and then click OK again.

      Tips In the Show Fields dialog box, to remove multiple fields at once from the box on the right, press CTRL and then select all the fields you want to remove. To quickly display the E-mail field in the Available fields box on the left, under Select available fields from, select E-mail fields.

   5. Click the first name in the list. Press SHIFT, scroll down, and click the last name in the list to select all the contacts.
   6. Press CTRL + C to copy the contacts.
   7. Open Microsoft Excel (or another spreadsheet program) or a text editor such as NotePad or WordPad.
   8. In the spreadsheet program, click the far left cell in the first row of the spreadsheet to select it.

      In a text editor, the cursor should be blinking in the top left corner of the document.
   9. Press CTRL + V to paste the contact names and email addresses into the spreadsheet or text editor. The labels Full Name and E-mail automatically appear at the top of the two columns.
  10. On the spreadsheet or text editor File menu, click Save As.
  11. For Save as type, select CSV (Comma delimited)(*.csv), if that's an option. Otherwise, choose Text document (*.txt).
  12. Type a name for the file, choose a location where you'll be able to find the file again, and then click Save.
Export to a XLS or PST file.
higs22Author Commented:
trying to export it to .csv file
higs22Author Commented:
will that work the same?
Glad I could help and thanks for the points!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.