How to extract address emails from outlook mail

There are a few ways to extract email addresses from Outlook mail:

Method 1: Using Outlook's built-in feature

1. Open Outlook and go to the "Mail" folder.
2. Select all the emails you want to extract addresses from by pressing Ctrl+A.
3. Right-click on the selected emails and choose "Export to a file".
4. In the "Export to a file" dialog box, select "Comma Separated Values (CSV)" as the file format.
5. Choose a location to save the file and click "Export".
6. Open the exported CSV file in a text editor or spreadsheet program like Microsoft Excel.
7. You can now extract the email addresses from the CSV file.

Method 2: Using VBA Macro

1. Open Outlook and go to the "Developer" tab (if you don't see it, go to "File" > "Options" > "Customize Ribbon" and check the box next to "Developer").

2. Click on the "Visual Basic" button in the "Developer" tab.

3. In the Visual Basic Editor, click "Insert" > "Module" to insert a new module.

4. Paste the following code into the module:

   Sub ExtractEmails()
    Dim olApp As New Outlook.Application
    Dim olNamespace As Outlook.Namespace
    Dim olFolder As MAPIFolder
    Dim olItems As Items
    Dim i As Integer
   
    Set olNamespace = olApp.GetNamespace("MAPI")
    Set olFolder = olNamespace.GetDefaultFolder(olFolderInbox)
    Set olItems = olFolder.Items
   
    For i = 1 To olItems.Count
        If olItems(i).Class = olMail Then
            Dim email As String
            email = olItems(i).To
            ' Do something with the email address, e.g. add it to a list
        End If
    Next i
   
    Set olItems = Nothing
    Set olFolder = Nothing
    Set olNamespace = Nothing
    Set olApp = Nothing
   End Sub

5. Click "Run" to execute the macro.

6. The macro will extract the email addresses from the selected emails and display them in a list.

Method 3: Using a third-party add-in

There are several third-party add-ins available that can help you extract email addresses from Outlook mail, such as:

• Email Extractor for Outlook
• Outlook Email Extractor
• Email Address Extractor

These add-ins can be downloaded and installed from the internet, and then used to extract email addresses from your Outlook mail.