Create link between my Excel file and MS Outlook (both 2007)

My inbox is configured to show Received, From, Subject, Message.  All of this information is helpful to me and I'd like to move it to my spreadsheet or create a hyperlink in my spreadsheet to each email I select.  My emails help me track inventory requests.

Currently I am going into Outlook/Edit/Copy then Paste into Excel which drops bits of data across a number of cells, which I then have to clean up manually.

I'd really like to have either:

1. A way to 'cut' all of the information in these four email fields (Received, From, Subject, Message) so that all of the contents get dropped into a single cell in Excel without me having to mop up different cells (I don't mind if formatting gets lost, it's just for reference), or
2. A way to link any email I select in Outlook from a cell in Excel, in other words, there would be a hyperlink within one cell in my s/s that would lead me to the correct email in Outlook.

Either way would allow me to fetch the details of the original email that helps me keep track of inventory requests.

I am using Windows 7 home, Office 2007.
apr8Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Aaron TomoskySD-WAN SimplifiedCommented:
Off topic. Check out xobni (inbox backwards). It's a free outlook plugin that helps a lot. May be good enough to not need your excel integration.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
austinstaceCommented:
You may be able to bypass the spreadsheet altogether. You could choose the indvidual emails in outlook and assign them to a category. Then, create a Search Folder for all emails in that category. When you go to the newly created search folder, you will get a list of all of the emails in that category.

If you need to specify multiple criteria (i.e. all messages in category marked for follow up), you will need to enable and use Query Builder. Instructions are at http://www.addictivetips.com/microsoft-office/outlook-2010-advanced-search-query-builder/.

If you really need to move the info to excel, you would have to use VBA to open the mail in Outlook and that is beyond me - today! Maybe I will learn it tomorrow ;)

Let me know if you need help clarifying anything I covered above.
0
apr8Author Commented:
Thanks for posts, but I want to have a record of the email embedded into my s/s for reference purposes, ie as an auditing tool if I need to go back in time and see the date, time and content of the email to reconcile against the actions that I took in response to the email.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

austinstaceCommented:
Without using VBA, you will need to save the email to a file. That will create a snapshot of the message at the time you save it. Replies, etc. will not be included when you open the file from the spreadsheet.
0
apr8Author Commented:
VB=Visual Basic, what does th A stand for?
0
apr8Author Commented:
I'm assigning a partial grade because I can't determine if the proposed solutions would work as I don't have the skills to learn VB and don't want to download another program.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.