Extracting Data from Outlook into Excel VBA

[uzzimacro]

Hi All,

Theres a really manual part of my day every morning where I have to look into about 5/6 emails and copy and past the table of data in the emails into excel.

Can anyone write a code that will look into outlook into a specific folder and to make it easy copy the UNREAD email into a specific range in Excel, so for example one table in the outlook email needs to be copied into G5:K13. Really appreciate the help.

Regards,

U-mac

 

[John_w]

Try the code at https://www.mrexcel.com/forum/excel...ted-folder-excel-post4727139.html#post4727139 as a starting point. Note the requirement to set the references.

To look at only unread emails, put "If oMail.UnRead Then" inside the outer For Next loop.