I am looking for someone to make a macro that will scan emails from a certain outlook folder (would prefer to choose what folder) and scan all the emails in it for certain fields.
We receive leads so the email will have this in the body:
Customer Information
Customer Name: John Doe
Contact Time: Any Phone – Anytime
Daytime Phone: 555-555-5555
Email: customers email address
Address: 111 Example Lane, City, VA 11111
Click here to set an appointment
Job Information
Description: Repair or Service a Central Air Conditioning System
Job Number: 11111111
Service Description
What is the nature of this project? Repair or service central air conditioning system
Request Stage Ready to Hire
Desired Completion Date 1 – 2 weeks
Property Owner Yes
Customer Comment: Customer did not provide additional comments. Please contact the customer to discuss the details of this project.
Basically we get a ton of emails like this a day and I would like to be able to scan a folder in outlook, it will then scan the emails in that folder, then the information will be passed to an excel xls spreadsheet.
the spreadsheet is already created on a shared folder on our work network. The location or name of how you input it in the code is not important, as long as you show me where to change it.
I may not need all the information in the email, but for now we will assume that we do.
I have been able to successfully import information into excel myself, however I have failed at parsing the exact text fields i need in the correct location.
