We help IT Professionals succeed at work.
Get Started

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

1,289 Views
Last Modified: 2012-05-11
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 :-)
Comment
Watch Question
CERTIFIED EXPERT
Top Expert 2011
Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE