VBA to Extract information from Outlook 365 to Excel 365

[mazher]

Hi please can someone help me to extarct the the following information from the sent folder of an email address ( I am using Office 365)

Cell A1 = Start Date
Cell B1 = End Date
Cell C1 = abcd@mydomain.com

I need the following infortion from the Sent Folder

Date, Time
Subject
Files names of the attachement.

In some sent items there are 50 than attachements and in some there are no attachements.
I need the information for only those emails sent where ther was an attachment.


Any help will be much appreciated @John_w

 

[shina67]

You can achieve this task using Microsoft Power Automate in Office 365.

Here's how to set it up:

Create a New Flow: Go to Power Automate in your Office 365 account and create a new flow.

Trigger:
Use the "Office 365 Outlook - When a new email is received" trigger. Configure it to monitor the Sent Items folder of the specified email address (Cell C1).

Filter for Emails with Attachments:
Add a condition to check if the email has attachments. You can use the "Has Attachments" property of the email.

Get Email Details:
Within the condition, use actions such as "Get email details" or "List attachments" to retrieve the required information like date, time, subject, and attachment file names.

Output to Excel:
Use the "Excel - Add a row into a table" action to add the extracted information to an Excel table. Set the table headers accordingly.

Apply Date Filter:
Use the "Filter array" action to filter emails based on the received date falling within the range specified in Cell A1 and B1.

Run the Flow:
Save and run the flow. It will now automatically extract information from the Sent Items folder of the specified email address for emails with attachments and populate the Excel table accordingly.

Make sure to adjust the actions and conditions according to your specific requirements and environment.