Outlook macro to save email body data into seperate colums in excel.
I will have this data in the subject to identify "Employee departure notice:"
I need to run it on a folder or be able to add this code to all emails that arrive.
Each day new excel file should be created.
The body of the email will be as this
The person noted here is leaving the organisation on 12/11/2010.
Employee: Paul, Andrew (IN190924) Job Title: Software Engineer Office location: USA
Manager: John, Raj
I want each of these in each colum
Andrew Paul | IN190924 | Software Engineer | USA | Raj John
The excel should look as above.