Applescript to add mail content to spreadsheet
Please help I know enough to be dangerous with Applescripting
I would like to add a script to a mail rule to put my banking transaction notification email into a spreadsheet.
I would like to extract the records from the text in the Mail subect line and put them into a spreadsheet with 5 Fields
The incoming mail has a subject line with -----
"RMB Private Bank:-) R553.85 paid from Single Fac. Acc..009939 @ Scheduled Pymt. Ref.Hamptons Levy-17. 28Sep 06:13"
I would like to add this to spreadsheet called "inContact.xlsx"
Using Fields
1. Account - "RMB Private Bank"
2. Amount - "R553.85"
3. Date - "28Sep 06:13"
4. Item - "Hamptons Levy-17"
5. Card Details - "Single Fac. Acc..009939"
Can anyone help PLEASE