Can I save an Outlook e-mail trail and hyperlink to it from Excel?

[GaryBC]

Hi guys

I have an Excel spreadsheet that tracks document reviews. One form of evidence that a document has been reviewed is an e-mail from the reviewer (eg, "I've reviewed it and told John to make corrections as per the attached").

Aside from printing the mail to a pdf and saving it somewhere (which could involve printing each mail and attachment separately, then linking them together somehow), is there any way the mail itself can be saved in such a manner as clicking the link will open up the mail and all its attachments?

Cheers,
Gaz

 

[CreepinJesus]

You can save Outlook emails as various file formats (.msg, .htm, .mht, etc.) with File > Save As, but I don't think these include the attachment, so this will have to be saved separately.

However, once you have both the email(s) and attachment(s) saved, you can bundle them up into a folder or zip file as use that, I suppose?

EDIT: as FliGi7 says below, .msg does include the attachment (thanks for that!)

 

[FliGi7]

Are you looking to save Outlook messages inside and Excel document, or an Excel document inside an Outlook message? Saving an outlook message as a .msg will save the accompanying attachments.