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.