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 :-)