|20 Dec 2011||#1|
| || |
Can I save an Outlook e-mail trail and hyperlink to it from Excel?
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?
|My System Specs|| |
|20 Dec 2011||#2|
| || |
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!)
|My System Specs|
|Similar help and support threads for: Can I save an Outlook e-mail trail and hyperlink to it from Excel?|
|Hyperlink not working on Office outlook 2007 on Windows 7||Microsoft Office|
|Need interpretive hyperlink preferably in cell within Excel||Microsoft Office|
|Microsoft Office Outlook 2010 Hyperlink Problem||Browsers & Mail|
|Cannot save excel files in a redirected folder unles I use save as||Network & Sharing|