troubleshooting Question
Outlook 2010 Macro, sets Start date flag based on text in body of e-mail
BITASCII
asked on
asked on
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 :-)
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 :-)
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.
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.