Transfer Outlook Mail data to Excel

[nasin123]

Hi, I am trying to export the MS Outlook email data ( Sender name, Subject, Mail body and Date and Time stamp From a Shared Mailbox to excel and need URGENT help in fixing the VBA code for the same.

I had tried using below code, but this pulls the data from only your current inbox ( and not the shared one) . EG : If my shared mail box name / path is "eTransfer" -> "Inbox", how do i incorporate this in below code?

Any help will be appreciated.


VBA Code:
____________________

Please Login or Register  to view this content.

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks

[dotchiejack]

Does this help?

Please Login or Register  to view this content.

[nasin123]

Thank you. I tried this code but getting this error : Compile Error: User Defined Type not Defined. Code is getting stopped at the very first line : Dim olApp As Outlook.Application, olNs As Outlook.Namespace.

Please help.

[dotchiejack]

References

It's an error that appears when a reference is missing.
In the VBA zditor
Try to add in Tools-> References:

Microsoft Excel [Your Version] Object Library
Microsoft Outlook [Your Version] Object Library
references.png

[nasin123]

This was Awesome. I tried again.. works like magic.. thank you so much

[dotchiejack]

Thanks for the feedback.

[falitaxo]

Hello team,
Good answer.

and if we need to export all e-mails from all folders/subfolders from the same mail address?
I have 3 differents mail address (mailbox), but every week, I need to export all e-mail from all these 3 mailbox and of course all folders and subfolders (more than 100 every mailbox).
So I spent more time searching internet option for export all e-mails including all subfolders, but.. no way.
So do you know, and alternative?
Thank so much.