Excel 2007 - From Outlook to spreadsheet
Posted on 2010-11-11
I get a bunch of emaiils in this form:
Transaction # 00000002E7-xxx
Account # USD-100-458475
Value date: 09/11/2010
Posted date: 09/11/2010
Currency: US Dollars
Credit / Debit: Credit
Is there an automated way of putting that data into a spreadsheet without having to always copy and paste? The column on the left would be the column headings and the values on the right of the above example would comprise one record (one row - so it transposes) and as each email comes in, some might have more than one of these but the left hand column would always be the same text.
So, as each email comes in, it would fill up this spreadsheet one row at a time. The workbook would be named DirectDepositTransfers.