How to copy outlook mail in excel

There are a few ways to copy Outlook mail into Excel, depending on your specific needs and the version of Outlook you're using. Here are a few methods:

Method 1: Using the "Export to CSV" feature in Outlook

Open Outlook and select the folder containing the emails you want to export.
Right-click on the folder and select "Export to a file" from the context menu.
In the "Export to a file" dialog box, select "Comma Separated Values (CSV)" as the file format.
Choose a location to save the file and click "Export".
Open the exported CSV file in Excel.

Method 2: Using the "Import and Export" feature in Outlook

Open Outlook and go to "File" > "Open & Export" > "Import/Export".
Select "Export to a file" and follow the prompts to select the folder and file format (CSV).
Choose a location to save the file and click "Export".
Open the exported CSV file in Excel.

Method 3: Using VBA macros in Outlook

Open Outlook and go to "Developer" > "Visual Basic Editor" (or press Alt + F11).
In the Visual Basic Editor, create a new module by clicking "Insert" > "Module".

Paste the following code into the module:

Sub ExportEmailsToExcel()
 Dim olApp As New Outlook.Application
 Dim olNamespace As Outlook.Namespace
 Dim olFolder As MAPIFolder
 Dim olItems As Items
 Dim i As Integer
 Dim j As Integer
 Dim strEmail As String
 Dim strSubject As String
 Dim strBody As String
 Dim strFrom As String
 Dim strTo As String
 Dim strCC As String
 Dim strBCC As String
 Dim strDate As String
 Dim strTime As String
 Dim strFile As String
 Dim strPath As String

 Set olNamespace = olApp.GetNamespace("MAPI")
 Set olFolder = olNamespace.GetDefaultFolder(olFolderInbox)
 Set olItems = olFolder.Items

 strFile = "Emails.csv"
 strPath = "C:\Emails\" & strFile

 Open strPath For Output As #1

 For i = 1 To olItems.Count
     strEmail = olItems(i).Subject
     strSubject = olItems(i).Subject
     strBody = olItems(i).Body
     strFrom = olItems(i).SenderEmailAddress
     strTo = olItems(i).To
     strCC = olItems(i).CC
     strBCC = olItems(i).BCC
     strDate = olItems(i).ReceivedTime
     strTime = olItems(i).ReceivedTime
     Print #1, strEmail & "," & strSubject & "," & strBody & "," & strFrom & "," & strTo & "," & strCC & "," & strBCC & "," & strDate & "," & strTime
 Next i

 Close #1

 Set olItems = Nothing
 Set olFolder = Nothing
 Set olNamespace = Nothing
 Set olApp = Nothing
End Sub

Save the module and close the Visual Basic Editor.
Go back to Outlook and run the macro by clicking "Developer" > "Macros" > "Run" > "ExportEmailsToExcel".
The macro will export the emails to a CSV file, which you can then open in Excel.

Method 4: Using a third-party add-in

There are several third-party add-ins available that allow you to export Outlook emails to Excel, such as Outlook Exporter or Export Outlook Emails. These add-ins often provide more features and flexibility than the built-in methods.

I hope these methods help you copy Outlook mail into Excel!

Mail Knowledge

How to copy outlook mail in excel