I have a certain task which is consuming a lot of my time. I rate myself 4/10 in excel so it will be great to ask you guys out there who are the 10/10!

Here is what I am looking for:

I have 20 different folders in outlook, each has same email body structure and format. each email body has 3 to 7 hyperlinks i want to export one of these hyperlinks (its easy to identify as it has a same starting/a specific word within - it doesn't matter if we export this specific hyperlink or all of them because we can later edit them within excel).

I want these hyperlinks to be exported into cells in excel sheet

WHAT I AM DOING RIGHT NOW:

I am using a clipboard to go to each email. right click copy link and then pasting into a notepad or excel.

let me know if you guys have any suggestions. This will really simplify my work.. and surely of any other who may look for similar solutions.

regards,

AA