Search code examples
excelvbaoutlookexport-to-excelonenote

Copy hyperlink from outlook email body and export to excel or notepad


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


Solution

  • Guys I am using codetwo outlook exporter to perform this task. I somehow stumbled upon it.. Thanks Marc nd Expfresh! your solutions are great but i found another way before even trying them.. This is great that this forum has helpful people. Just for people facing the same problem: USE CODETWO outlook Exporter. - Does the job. regards - Addy