Export Outlook Emails' Info To Excel Using VBA | Outlook VBA

Your donation will support me to continue to make more tutorial videos!

Microsoft Outlook is a powerful email/contact/calendar/note management application, and normally, you can export emails from Outlook to Excel with few manual import/export steps. But what if you can automate the entire process with simply just once click of button?

In this tutorial, I will walk you through how to write a VBA macro to automate the process of exporting Outlook emails to Excel spreadsheet.

VBA Code

Microsoft Outlook MailItem Doc

Visit my website

Supporting my channel so I can continue keep making free contents
--------------------------------------------------------------------------------------------------------------

[kristis]

is it possible to export also the received and the date replied of an email?

[jacobfranklin]

Make sure you have your Microsoft Excel Object Library checked in Tools>References... I was getting an error when compiling

[dasrotrad]

Excellent... But, how do you extract sender's IP Address to Excel? Thank you.

[sherifmudavan]

hello sir, could you guid me how to email from specfic folders Like under > inbox > folder1 > and inside folder2 > how to give path or how to download wherever we selected. Thank you

[eleanortay]

Hi Jie Jenn, may I know if you would know how to incorporate the ConversationIndex Property into your code above to track if sent emails have been replied?

[wilsalazar]

Great info. Thanks a lot. However, how to set up the corresponding fields in excel where the records are going to be saved. That part is not clear in this video

[nicolasantoniomirasnunez]

Hi, I have been trying to export the subject, sender email address, recived time and also the name of PDF's that i have in my emails. I am using "FileName" but I do not why I can not export it. Could you help me please?

[vvittoriotenor]

Hello, could use some help: What references do you have activated during this tutorial? When I compile, it errors out with "User-defined type not defined" and highlights the Sub List_Email_Info() . I have Visual Basic for Applications, Microsoft Outlook 16.0 Object Library, OLE Automation, and Microsoft Office 16.0 Object Library checked off. Thanks!

[dominicschober]

Hi, could you advise the coding if I want to extract the date and time of an email sent from a specific email subfolder in my outlook?

[aravindmolugu]

How can we we about reading the body content of he outlook report item? Email Item(class 43 ) works fine, but the item.Body attribute of the ReportItem returns gibberish / chinese characters

[sumaiyanazeer]

Hi can this be done in outlook chrome version?

[jamesrios]

Two questions. First, is there a way to get the above macro to work on the "current" folder? I have an inbox with sub folders and ideally would like to select any folder and then be able to export the items included in your macro. Second, is there an addition to add the "body" of the email to the export? thank you.

[snigdhaagrawal]

I want to import only those email from outlook which has specific text in subject or body or sender domain name, say ex: only those email say "pepsi" , how can I do that . can someone please help with code.

[calvinjames]

Hi Jie, Thanks for this video, I am getting only couple of rows (email info) when I have over 1000+ emails I am trying to extract. My counter initialised before the For > Next and increment by 1 is sitting inside. same as yours. Not sure why it stops after couple of records. I monitored via debug it does not seem to encounter any errors. It does not go to On Error however, after 2 records it goes to the msgbox "export completed". Any helpful hints ?

[savvyweb]

I'm re-running the code (your code) that successfully ran about a month ago. But now, it skips a month. It will export email in MAR and MAY but not APR. Do you know why? There is email dated April, not sure why it's being skipped.

[Nileshkonde]

after 58 records its shows Export Complete. I wanted to increase it to 3000 records. Is it possible? Also, need email ids instead of sender names. Also body massage.

[rakeshvengatesan]

Thanks for your video it helped. What if I want to import mails on a specifc date.. kindly advise on it.

[jeremiahkeltner]

Is there a way to do this not on the inbox folder?

[offerzone]

Can anyone help me how to save email from Outlook to desktop folder

[sethsacks]

Has anyone else had their export cut off after adding or removing sync'd accounts from outlook?