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: outlook macro parse email text, macro parse email, outlook macro parse email, parse email excel, parsing email body outlook, outlook macro parse email text excel, macro parse emails excel, parse outlook email excel, parse email body outlook macro, stage hire, ready to hire, parsing input, need to hire a va, need someone to do a excel project, looking for job at excel, how to hire someone, how outlook, how do i get to work from here, hire someone to do excel, hire a va for a project, excel macro how to, email customer service job, correct email address, outlook parsing email body, parse email body excel outlook macro

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

Proje NO: #2240597