How to export address book from outlook 2007 to excel
![how to export address book from outlook 2007 to excel how to export address book from outlook 2007 to excel](https://lts.lehigh.edu/sites/lts.lehigh.edu/files/Excel_ipad1.jpg)
When the Outlook Address Book service has already been added and the option to select the Contacts folder as an Outlook Address Book is still disabled and greyed out, it means that the Outlook Address Book service is corrupted. Your default Contacts folder should already be selected and is not removable. You should now be able to select Contacts by using the Address Book. To do so right click the Contacts folder and choose Properties-> tab Outlook Address Book-> select option Show this folder as an e-mail Address Book. If the Outlook Address Book service is added into the profile you can make any Contacts folder (so even the additional ones you may have made yourself already) show in the Address Book. Make sure that the Contacts folder is marked as an Outlook Address Book Press OK and close and restart Outlook.You’ll be prompted that you must close and restart Outlook for changes to take effect.Choose “Outlook Address Book” and click Next.Select “Additional Address Books” and click Next.If the Outlook Address Book service has not been added yet, press the New... button.If the Outlook Address Book service is added already, you should mark your Contacts folder as an Outlook Address Book.Outlook 2010 / 2013 / 2016 / 2019 and Office 365įile-> Account Settings-> Account Settings…-> tab Address Books.Tools-> Account Settings…-> tab Address Books Open the Address Book lists for your mail profile.You can add this service in the following way. Outlook can only show contacts from your Contacts folder(s) in the Address Book when the Outlook Address Book Service has been added to your mail profile. Click the Browse option to provide the destination. Next, under the Contacts section, select the GAL folder and click Next. In the Export to a file wizard, select Comma Separated Values and click Next. Note: In Outlook 2007, you can also temporarily change the default Contacts creation folder. In the Import and Export wizard, select Export to a file and click Next. You can then easily move your filtered list of contacts to another folder and use the Export option in Outlook to export this folder or customize your view with the fields you need and copy them directly to Excel. Make sure the Outlook Address Book service is added to the Mail Profile In the Outlook application, go to File > Open & Export > Import/Export. Make sure that the Contacts folder is marked as an Outlook Address Book.Make sure the Outlook Address Book service is added to the Mail Profile.This guides lists the two things you’ll need to check and set correctly, and offers a solution in case that fails. The Address Book in Outlook 2007/2010/2013/2016/2019 if you are using Classic Menu for Office If you have not Classic Menu for Office (Method: Message tab) Ribbon Interface of Microsoft Outlook 2007, 2010, 2013, 2016, 2019 and 365 are different from classic style interface of Outlook 2003. When trying to use the Address Book to address a message to a contact, you could find that the contacts from your Contacts folder aren’t listed.