cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anba_sv
New Member

Extract email data to excel file

Hi Team. 

i’m a beginner for this app. Need to automatically extract email subject details and “to” to excel format whenever there is an email received. Common email subject “reminder”. Could you assist with the flow.

 

sample email.

subject : undelivered: reminder IN0C_125689

to: jcmail@yahoo.com

 

i would like to extract the brow details to excel format. 

1) IN0C

2) 125689

3) jcmail@yahoo.com

 

thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
askondo
Community Support
Community Support

You can add data to your Excel table when the mail arrives in your mailbox by setting up the following
For the title, the SubString function can be used to extract a specific string of characters.
The extraction method depends on the format of the title of the mail you receive.

 

MicrosoftTeams-image (4).png

 

MicrosoftTeams-image (4).png

View solution in original post

3 REPLIES 3
anba_sv
New Member

sample email

 

anba_sv_0-1597730777777.png

 

askondo
Community Support
Community Support

You can add data to your Excel table when the mail arrives in your mailbox by setting up the following
For the title, the SubString function can be used to extract a specific string of characters.
The extraction method depends on the format of the title of the mail you receive.

 

MicrosoftTeams-image (4).png

 

MicrosoftTeams-image (4).png

View solution in original post

Dear.
Appreciate your assistance. Could you guide me step by step from scratch until data is extract to excel on this.. thanks you in advance. U may email me as well anba_sv@yahoo.com

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (3,631)