How to export Outlook Global Address List (address book) to Excel?
As we know, the Global Address List or Address books are virtual folders in Outlook. We can view and use contacts in these virtual folders, but it’s hard to print or export the contacts from them. But, this article will introduce a roundabout way to export Global Address List or Address book from Outlook to Excel.
Aug 25, 2016. Jul 04, 2019.
Export Outlook Global Address List or Address Book to Excel with Kutools for Outlook
Outlook addin address book free download - Outlook Addin for QuickBooks, Free Address Book, Easy Address Book, and many more programs. Finally, move this file to your Mac, launch Address Book, and choose File - Import - LDIF. Navigate to the LDIF file you brought over from Windows and import it. Your Outlook contacts will.
One click to save/export multiple emails to text/PDF/HTML/CSV files in bulk in Outlook
Normally we can export/save an email message as a text file with the Save As feature in Outlook. But, for batch saving/exporting multiple emails to individual text files, you have to manually handle each message one by one. Time-consuming! Tedious! Now, Kutools for Outlook's Save as File feature can help you quickly save multiple email messages to individual text files, PDF files, HTML files, etc. with only one click! Click for 60-day free trial without limitation!
- Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by rules; 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 at once; Auto Add Greeting when reply; Auto Add Date&Time into subject...
- Attachment Tools: Auto Detach, Compress All, Rename All, Auto Save All... Quick Report, Count Selected Mails, Remove Duplicate Mails and Contacts...
- More than 100 advanced features will solve most of your problems in Outlook 2010-2019 and 365. Full features 60-day free trial.
Export Outlook Global Address List or Address Book to Excel
Please follow below steps to export the Global Address List or an Address Book from Outlook to Excel.
1. Create a new email with clicking Home > New Email.
2. Go to the new Message window, and click the To button in the message header. See screenshot:
3. In the Select Names box, please (see screenshot below):
(1) Select the Global Address List from the Address Book drop down list;
(2) Select all contacts with holding the Shift key and clicking the first contact and the last one;
(3) Click the To --> button to add all contacts as email recipients.
(4) Click the OK button.
4. Now you get back to the message window. Please select all recipients in the To filed, right click and select Copy from the right-clicking menu. See screenshot:
5. Create a new workbook, right click a blank cell and select Keep Text Only in right-clicking menu.
Now all contacts of the Global Address List are pasted into the selected cell in Excel.
Microsoft Outlook Download For Mac
6. Keep selecting the cell, and click Data > Text to Columns.
7. In the Convert Text to Columns Wizard – Step 1 of 3, please check the Delimited option and click the Next button.
8. In the Convert Text to Columns Wizard – Step 2 of 3, please only check the Semicolon option, and click the Finish button.
And now all contacts of the Global Address List are pasted into a row in Excel.
9. Select and copy the cell with contacts, right click a blank cell and select Transpose (T) from the right clicking menu.
And now all contact of the Global Address List are pasted into a column (See screenshot above). And you can delete the row of contacts as you need.
10. Click File > Save, and then in the Save As dialog box, please: (1) Specify the destination folder you will save the workbook into; (2) Name the new workbook in the File name box; (3) Click the Save button.
So far we have exported the contacts of Global Address List from Outlook to Excel already.
Export Outlook Global Address List or Address Book to Excel with Kutools for Outlook
This method will guide you to save the Global Address list as individual contacts in a new contact folder firstly, and then export these contacts to Excel.
Kutools for Outlook: Add more than 100 handy tools for Outlook, free to try with no limitation in 60 days. Read More Free Trial Now
1. Go to the People (or Contact) view, create a new contact folder, and then in the new contact folder click Home > New Contact Folder.
2. In the Contact Group window, type a name for the new contact folder in the Name box, and then click Contact Group > Add Members > From Address Book. See screenshot:
3. Now in the Select Members dialog box, please: (1) Select the Global Address List from the Address Book drop down list; (2) Holding the Shift, select all contacts with clicking the first contact and the last one; (3) Click the Members button; (4) Click the OK button.
4. Now you return to the Contact Group window. Please click the Save & Close button.
5. Now select the new contact group, and click Kutools > Contact Group.
6. In the Break dialog, click the All button to select all memebers, click the Ok button, and finally click the Yes button in the new Kutools for Outlook dialog. See screenshot:
7. Change the contact folder view with clicking View > Change View > Phone.
8. Select and copy all contacts in the contact folder, paste into a new workbook, and finally save the new workbook.
Notes:
(1) You can select all contacts in a contact folder with selecting any contact in it and pressing the Ctrl + A keys at the same time;
(2) Press Ctrl + C keys simultaneously to copy selected contacts, and press Ctrl + V keys simultaneously to paste.
Kutools for Outlook: Add more than 100 handy tools for Outlook, free to try with no limitation in 60 days. Read More Free Trial Now
Demo: Export Outlook Global Address List or Address Book to Excel
Tip: In this Video, Kutools tab is added by Kutools for Outlook. If you need it, please click here to have a 60-day free trial without limitation!
Related Articles
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.
- To post as a guest, your comment is unpublished.Thank You very much for new Trick. How to get Phone number against email id? Kindly Reply
- To post as a guest, your comment is unpublished.Terrible. The images here are not what is in the program and the protocols here do not work. Fail, Fail, Fail'
Just another weak offering trying to fix the even weaker MS outlook weakness. Just another worthless exploration. - To post as a guest, your comment is unpublished.Globally an Outlook Address Book can be Exported in various ways. You Explained it in best way. I also did some work on it for your viewers. I hope they will like it.
https://gallery.technet.microsoft.com/Which-is-a-better-Option-0f15d8bf
If you have the same query or related to it to export Outlook 2011 contacts to Mac Address Book you came the right place read this write-up to know the solution of your problem.
We are going to explain both manual and the automated solution read them one-by-one without wasting much of your time let’s move to the process.
Manual Method to Add Mac Outlook Contacts to Mac Address Book
Mac Outlook preserves its contacts in the OLM file format. In this step, we will guide you on how to export Outlook 2011 contacts to Mac Address Book.
- Launch Mac Outlook on your Macintosh
- Navigate the File Menu and choose the Export option
- Then click on Contacts and click on Continue button
- Choose the folder for your resultant file and click on Save As button
- Wait till the process is completed and click on Finish button
Professional Method to Export Outlook 2011 Contacts to Mac Address Book
Follow the steps one by one to add Mac Outlook contacts to Mac Address book without any technical assistance.
Step-1:Convert Outlook Contacts to CSV file format
It is an important step to export Outlook 2011 contacts to Mac Address Book because OLM files are only supportable by Mac Outlook and no other platform supports the OLM file. But many platforms support the CSV files and you can easily access your contacts from several email clients. Follow the given steps to convert Outlook to CSV file format:
- Download and open the OLM to CSV Converter tool
- Hit the Add File/Folder button
- Choose your OLM file that you want to convert
- Then choose Export All folder/ Export Selected folder as required
- Select CSV option to transfer OLM to CSV file format
- Locate the destination folder at where you want to preserve your resultant file
- Click on Export button to initiate the process
- Wait till the process gets completed then hit the Ok button
Outlook Download Address Book Mac Pro
Step-2:Import the CSV file into Mac Address book
Thesesteps will import your exported CSV file into your Mac Address Book.
- Open Contacts by searching profile in the application folder or you can directly open the contacts by CMD+F and type contacts into the Finder window
- Navigate the File menu and choose Import from the Mac menu at the top of your screen
- Choose a CSV file from where you have stored it and launch it
- Check Ignore first card to ignore headers in your CSV file
- Click on the dropdown menu next to every item to make sure it’s correctly categorized in contacts. Such as name, phone number, etc.
Tip: You only need todo this at once then it will handle all the rest of your contacts so you don’tneed to do this individually.
- Then hit the OK button
Now, you successfully exported Outlook 2011 contacts to Mac Address Book.
AdditionalFeatures of Tool
- This tool permits you to export contacts, contacts, etc into more than 8 file formats.
- Allow you to convert Mac Outlook contacts from the OLM file.
- Users can also export selective data by using the data filter option.
- Also, allow the preview of the OLM file before conversion.
- Capable to save Outlook email as HTML in Mac
- Compatible with all the versions.
Summering Up
There are many users who want to export their Outlook Contacts to Mac Address Book and some frequently asked queries are also discussed above. If you are also one of them then go through the complete article and hope you will find the best approach for your query of “How to Export Outlook 2011 Contacts to Mac Address Book”. Follow the steps and you will able to add Mac Outlook contacts to Mac Address book in a trouble-free manner.
Comments are closed.