Export list of emails from outlook

Here are the steps to export a list of emails from Outlook:

Method 1: Exporting emails using Outlook's built-in feature

1. Open Outlook and go to the folder that contains the emails you want to export.
2. Select all the emails you want to export by pressing Ctrl+A.
3. Right-click on the selected emails and choose "Export to a file" from the context menu.
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 enter a file name.
6. Click "Export" to start the export process.

Method 2: Using Outlook's VBA Macro

1. Open Outlook and go to the folder that contains the emails you want to export.

2. Press Alt+F11 to open the Visual Basic Editor.

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

4. Paste the following code into the module:

   Sub ExportEmails()
    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
            Debug.Print olItems(i).Subject & " - " & olItems(i).ReceivedTime
        End If
    Next i
   
    olApp.Quit
   End Sub

5. Click "Run" to execute the macro.

6. The macro will export the email subjects and received dates to the Immediate window. You can copy and paste this data into a CSV file or another spreadsheet program.

Method 3: Using a third-party add-in

There are several third-party add-ins available that can help you export emails from Outlook, such as Export Emails, Outlook Export, or Email Exporter. These add-ins often provide more advanced features and options for customizing the export process.