Forum

Retrieving data fro...
 
Notifications
Clear all

Retrieving data from saved emails (Outlook)

3 Posts
2 Users
0 Reactions
78 Views
(@bill-jone)
Posts: 28
Eminent Member
Topic starter
 

Hello!

Attached macro help me to get below items from Outlook directly.

Sender
Subject
Received Time
To
CC
Location
Body

Please I need a slight modification, instead of checking emails from outlook folder, can it do the same for the emails saved in a desktop folder?

I have about 700 emails saved in a folder in desktop,  I want to extract same info from those emails.

Thanks;

Bill

 
Posted : 27/09/2021 5:08 pm
(@purfleet)
Posts: 412
Reputable Member
 

Not VBA but have you looked at getting emails in Power Query?

you can connect directly to Microsoft Exchange and then just refresh - i know nothing about power query but have set one up in work in 30 mins.

Well worth a look

 
Posted : 28/09/2021 2:01 pm
(@bill-jone)
Posts: 28
Eminent Member
Topic starter
 

Thanks Purfleet, I will check power query.

I just need your help how I can select sub folder from my Inbox

Example: I have sub folder "My team" in my INBOX so can you update the attached macro to deal with this sub folder not all INBOX.

Thanks;

Bill

 
Posted : 28/09/2021 6:07 pm
Share: