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 :-)
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.