Devam Ediyor

494682 Outlook macro to parse email body information and save EXCEL

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.

Beceriler: Her şey Kabul, Excel

Daha fazlasını görün: parsing email body outlook, ready hire, parsing input, need someone excel project, looking job excel, how outlook, hire someone excel, email customer service job, correct email address, outlook parsing email body, outlook customer service, additional comments, text parsing, shared folder, save excel, macro, lane, repair, hire excel, excel service, email spreadsheet

İşveren Hakkında:
( 0 değerlendirme ) mesa, United States

Proje NO: #2240597