I use a 2003 Excel spreadsheet to monitor account moves within our company.
User experience with Excel varies from low to high. Many people are
accessing the spreadsheet through SharePoint. Among the many pieces of
information that is gathered is an Outlook email approval to move the
account. This email approval needs to be referenced on the spreadsheet and
allow other users to easily read through the email. Here are the solutions
we have tried, but without much success.

1. Use a different tab for the email - Used a form field to place a scroll
box where the contents of the email could be pasted. Difficult to maintain,
especially to match up the line item on one sheet with the email section on
the other. We also had difficulty in pasting and sometimes the form box
would not accept the paste. Also, we had hundreds of email approvals from
across the country, so we ended up with a ton of extra tabs to hold them all.
Copying information from one sheet to another also ended up as tedious.

2. Comment box - this took care of the copying problem as well as the many
tabs. Also became very handy because when you copying the whole line, the
comments went with. No references to another tab. But, there is no scolling
in comments and the type gets small. So this was an improved method, but
still not quite there.

In reading some other posts about this, I did try to export the email as
embed it as a object, but I can see how my less knowlegable users may find
that difficult and confusing.

What I'm looking for is a easy way to attach/embed/include an email in a
cell that is easily clicked on and read without making it too difficult for
less experienced people. I can develop macros to help facilitate the
process, but I really can't think of the best way to get Outlook and Excel
talking in the same file.

Any help would be most appreciated.