At the top of your Outlook ribbon, choose File. Choose Open & Export Import /Export. Choose Import from another program or file and then click Next. Tip: If you are prompted to enter a password and you haven't set a password, click Cancel to move to the next window. Before outlook, I was able to highlight a column of emails in excel and copy and paste them into a hotmail email for distribution of a message to my list members. Now it only pastes the first name in my list column and will not paste the entire list of 20 names into an address (bc) as a copy to or a blind copy.
How to export contacts from Outlook to Excel spreadsheet?
Exporting Outlook contacts to a file is an easy way for you to import the contact file into other applications. You can get rid of typing the same contact information over and over again by using the following method.
Export contacts from outlook to excel spreasheet
1. After launch your outlook, click File > Options. See screenshot:
2. When the Outlook Options window popup, click Advanced. In the right pane, click Export button.
3. In the Import and Export Wizard dialog, select Export to a file option, and then click Next button.
4. Select Microsoft Excel 97-2003, then click Next button. See screenshot:
5. Under the Select folder to export from, select Contacts option, then click Next to continue.
6. Under Save exported file as, click Browse button to select a destination folder.
7. In the File name column, type a name for the file. And then click OK button. After clicking OK button, it returns to the previous window, click Next, See screenshot:
8. If you want to manually customize the map by yourself, click Map Custom Fileds button. See screenshot:
9. If you don’t like the default setting, click on the Clear Map button to remove all the values on the right pane. And then you should choose your own value from the left pane. Just like the instructions giving in the dialog box: you need to drag the values from the source file on the left, and drop them on the appropriate destination field on the right. When finish setting, click on OK button.
10. Then it turns to the previous window, click on Finish button. Now, an Excel file with outlook contacts information is created.
Export contacts from outlook to excel spreadsheet in Outlook 2013/2016
If you are working in Outlook 2013/2016, the steps will be much easier.
1. Click File > Open&Export > Import/Export.
2. In the Import and Export Wizard, select Export to a file, click Next.
3. Select Comma Separated Values from the list box, click Next.
4. Select the contacts folder you want to export to a sheet in the Export to a file dialog. Click Next.
5. Click Browse to select a folder to place the new sheet which will contains contacts, and give it a name. Click OK > Next > Finish.
Then the contacts have been exported as csv file.
6. Open the csv file which you have create just now, click File > Save As and select Excel Workbook from Save as type drop down list in the Save As dialog. Click Save.
Now the contacts have been exported to a sheet.
Save or Export Multiple emails to other fomat files(PDF/HTML/WORD/EXCEL) in Outlook |
Sometimes, you may want to save or export the emails to a folder as other format files, such as PDF, Word or Excel files in Outlook. In Outlook, neither of the Save as and Export function can handle this job. However, Kutools for Outlook's Save as file utility can export multiple emails to a folder as files with multiple formats at once time . Click for 60 days free trial! |
Kutools for Outlook: with dozens of handy Outlook add-ins, free to try with no limitation in 60 days. |
Kutools for Outlook - Brings 100 Advanced Features to Outlook, and Make Work Much Easier!
- Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by custom; Auto Reply without exchange server, and more automatic features...
- BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features...
- Reply (All) With All Attachments in the mail conversation; Reply Many Emails in seconds; Auto Add Greeting when reply; Add Date into subject...
- Attachment Tools: Manage All Attachments in All Mails, Auto Detach, Compress All, Rename All, Save All... Quick Report, Count Selected Mails...
- Powerful Junk Emails by custom; Remove Duplicate Mails and Contacts... Enable you to do smarter, faster and better in Outlook.
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
- To post as a guest, your comment is unpublished.i did not find any e-mail address at excell sheet through above method ...
- To post as a guest, your comment is unpublished.I was able to export the file to an Excel spreadsheet, except that it didn't export my user-defined columns, which made the spreadsheet useless! I could not see any way to do that. Do you?
- To post as a guest, your comment is unpublished.I also could export but all went into one coloumn and I couldn't separate name from email so is useless. who has figured it out?
- To post as a guest, your comment is unpublished.I had created an distribution list that I now want to export to excel. I need to be able to see each of the names in the list but using this export function does not allow me to do that. Please help :) Thanks
- To post as a guest, your comment is unpublished.I managed to export the 'contacts' folder to Excel file, but No data!
What am I doing wrong? - To post as a guest, your comment is unpublished.very helpful, i love it
- To post as a guest, your comment is unpublished.Here is the instructions on how to export contacts into excel. If you have any questions please let me know.
Thank you,
Maria- To post as a guest, your comment is unpublished.If I export contacts into excel will I loose them in Outlook? I want to copy contacts to excel, not permanently move them to excel.
- To post as a guest, your comment is unpublished.Instructions on how to export contacts into excel
- To post as a guest, your comment is unpublished.Here's the instructions on how to export contacts
Learning has never been so easy!
When needing to convert a column of email addresses in Excel to a usable list in Outlook.
Notes: These instructions work for both PC and Mac computers, Using Outlook or Outlook Web Access. The email addresses must be complete ([email protected]) and listed in a single Excel column to use these instructions successfully.
![How To Copy Email Addresses From Excel Into Outlook For Mac How To Copy Email Addresses From Excel Into Outlook For Mac](/uploads/1/1/9/5/119500357/355274136.png)
6 Steps total
Step 1: Copy and Paste
Copy and paste the column of email addresses into a blank Microsoft Word document.
Step 2: Clipboard
A small clipboard appears to the right of the data. Click on this once and select 'Keep Text Only'.
Step 3: Replace
Click the 'REPLACE' button on the Home tab (sometimes found under Edit > Replace).
Step 4: FIND
Click inside the 'Find what' box and enter ^p (Hint: The carat symbol '^' is typed using Shift+6).
Step 5: Replace
Click inside the 'Replace with' box and type in a semi-colon.
How To Copy Email Addresses From Excel Into Outlook For Mac Osx
Step 6: Replace All
![How to copy email address from excel to outlook How to copy email address from excel to outlook](/uploads/1/1/9/5/119500357/998342523.png)
Click the 'Replace All' button. When the process is finished, hit OK and close the Find/Replace window.
You now have a list that can be copied and pasted into the TO, CC or BCC sections of an Outlook email message.
Published: Feb 20, 2017 · Last Updated: Sep 04, 2015