I want to have a script with the following functionality
- when I receive a mail in my Microsoft Outlook that contains the word "Beatles" then it takes some text from the mail and puts it in a excel file.
i need the following text from the mail:
sender: (in the example John Doe)
the time (T1) the sender sent me the mail originally (in the example: December 21, 2010 10:11 PM)
the three favorite Beatles songs (in the example: Come Together, Hello Goodbye, The Fool On the Hill)
the time (T2) I sent the original request (in the example: 11/22/10 5:29 AM)
The result of the script is a new line in an existing excel file. The line contains 7 cells:
1- index
2- sender
3- time T1
4- song 1
5- song 2
6- song 3
7- time T2
Please note the attached example of an incoming email.