troubleshooting Question

Outlook 2010 Macro, sets Start date flag based on text in body of e-mail

Avatar of BITASCII
BITASCIIFlag for United States of America asked on
VB ScriptOutlookMicrosoft Office
4 Comments1 Solution1292 ViewsLast Modified:
Hi, SQL server sends e-mail each time a meeting reservation is confirmed. On some line in body of e-mail the label 'Meeting Start:'  appears on a new line, always after a blank line.  That label is followed by meeting start date information in the format mm/dd/yyyy.  2 examples are pasted below - disregard any time info, we are only interested in start date.

Does anyone know how in Outlook 2010 a vba macro can grab the date in body of above mentioned e-mail, set flag and set the Start date same as date in body of e-mail?

Here is how the sart date appears in body of e-mail -- first the blank line, then Meeting Start label, followed by date ...

Meeting Start:    11/16/2010 2:00:00 PM

Meeting Start:         5/17/2011 11:00:00 AM (Eastern Standard Time)

Appreciate any thoughts/solutions.  Volume of generated e-mails is up, a macro to set flag and start date would eliminate number of user errors.  Thanks :-)
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros