I have a need to take data that is submitted in as an email, and to take the data and append it to an Excel workbook. The email always has the subject line Enquiry form details
I am unable to change or specify the format of the email, which is recieved in Outlook (2003) and looks like this: (everything between the dashes)
The following details were submitted:
First Name: Ann
Address: 1415 Long Street
Address 2: Suberbia
County: County Name
Postcode: AA00 B99
Telephone: 00000 000000
Age range: 25-34
Interests: Shopping Break, Tour of Cornwall, Theatre Break
I need to automate the appending of this data to an excel(2003) workbook, the workbook column headings DO correspond to the field names in the email, but the the Interests field may include up to 5 entries (seperated by commas) which need to be recorded in seperate columns - look at the attached XL file and you will see what I mean.
Can anyone help with this?
Perhaps a rule that can run a macro ?
or some other automated or semi-automated way to add data from emails to the workbook - a sample of the workbook is attached.