Formula or macro to read email and record date received if subject matches the order number

MickeyW

New Member
Joined
Apr 2, 2021
Messages
5
Office Version
  1. 365
Platform
  1. Windows
Hi All,

This is probably way way out of my depth with excel... But I love it

I have a dispatch register where we update the date received column when we receive an email from the lab. This allows us to determine the time it takes us to send off samples, process them to when we receive the data.
The subject contains the order number but not perfectly. For example, our spread sheet has a submission number of SAM21050801and the email will come back with a subject of "Order No : SAM21050801".

1620439812130.png


I'd like to have something running in the background (without slowing the workbook down significantly) that can go through my inbox, look for the matching subject to the submission number (Column F) and bring back the data the email was received (column G). I think it would be possible, I'm just not sure how to go about it.

Any help would be much appreciated :)

Thank you!
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,141,405
Messages
5,706,261
Members
421,437
Latest member
GijoeBlack

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top