Macro to extract amount from email (outlook) and copy/paste into Excel

THe macro needs to search inbox from specific email and copy paste the account # into excel sheet

Hi,
I'm not able to look at your attachments (issue my end) but this might be helpful.
Also this tested in O365, but it's late-bound so shouldn't require any references.

It looks through the inbox and looks at emails received today from the email specified.
It then splits the body into an array by space and checks each element to see if it's 10 digit number.
If it is it adds it to the worksheet.

Please Login or Register  to view this content.