Import Mail IDs from Outlook Email to Excel

Fetch Email Addresses – Quick Install & Test Code

• Open MS Outlook and Select any mail in Inbox or any other Folder
• Open new Excel Workbook, Alt+F11, Copy Paste the code in this Article
• In Excel VB Editor go to Tools->References->Add Microsoft Outlook nn.n Object Library
• Press F5.

All Email-Ids (“To”) in the mail you have selected is extracted to Excel. Sample Template is attached at the end of this article.

Fetch Recipients Email Ids to Excel

Some mails that we receive from Outlook have too many mail ids in “To”, “CC” or “BCC” sections.

If you want to extract these mails ids to an Excel Sheet for any tracking purpose, you have to copy them, paste to notepad and choose each contacts separately or you can choose to import it into excel with delimiter as “;”. Either ways, you will get only the contact name but not the actual Email Id.

Read Selected Mail Details from Outlook

Using the below code, you can directly extract Email ID from a selected Outlook Mail. Follow the instructions mentioned in Quick Install at the beginning of this post.

 

---

””””””””””””””””””””””””””””””””””””””

You can see in First sheet of Excel, the Email Subject and Email Ids of contacts in “To” are fetched. In similar way, you can modify this code to fetch the mail ids of contacts in ‘CC’ or ‘BCC’.

To know more about the Email properties, study more on Outlook, Recipients, MailItem properties from MSDN library. Here you will be able to get additional information and syntax for the commands used above.

Courtesy: Office Tricks