dougsmiley
04-26-2011, 05:16 PM
Im a complete noob, while willing to learn I would also be willing to pay for a complete macro that does this.
Heres the problem im looking to tackle for my company.
We receive work orders via email, I would like a macro that parses all new email in a folder every hour or so, strips out the relevant information, and creates a new appointment in the calendar.
It needs to search the emails for "Scheduled date and time:" if it doesn't find that, it needs to flag the email and move on (there is a specific email address/folder that is only for workorders, so if its not found it would be an error). If it finds scheduled date and time, it needs to create a calendar entry based on the info, and then use the subject line as the subject of the event.
The emails are in this basic format:
Subject: This is a Work Order
Blah Blah Blah
Scheduled date and time: 1/1/2011 8:00 AM
Blah
Blah
Blah
Heres the problem im looking to tackle for my company.
We receive work orders via email, I would like a macro that parses all new email in a folder every hour or so, strips out the relevant information, and creates a new appointment in the calendar.
It needs to search the emails for "Scheduled date and time:" if it doesn't find that, it needs to flag the email and move on (there is a specific email address/folder that is only for workorders, so if its not found it would be an error). If it finds scheduled date and time, it needs to create a calendar entry based on the info, and then use the subject line as the subject of the event.
The emails are in this basic format:
Subject: This is a Work Order
Blah Blah Blah
Scheduled date and time: 1/1/2011 8:00 AM
Blah
Blah
Blah