Excel linking outlook emails to excel

[joannesmithers]

Hi There,
I am a complete novice at coding but I was wondering if there is a way of linking an excel document to open outlook emails. I have a database of nearly 5000 emails in a public folder and I need to find a way of compliling a document to make it easy to view and access the emails.
I was hoping there was a way of creating a link from the excel document to specfic emails. the emails are applications. Does this make sense?
for instance
joanne smithers f 33 animals wants to swim with dolphins
billy johnson m 27 animals wants to work in a zoo

then if someone wanted to know more they could just click on the name and it would link to the original email?

any help you could give me would be great!

many thanks

Jo