I run a company that needs to be able to audit sessions for accurate info, The session ID's are sent in an email like below, I need to be able to extract the session ID, 283193 and execute a program like C:\[login to view URL] -283193
I know nothing about VBA, or setting it up in outlook. Shouldn't be too hard using a regex script/routine. Please bid if you can write the script, remotely log in and configure it in outlook to run on new email in a certain account.
Example Email:
--------------------------------------------------------
Dear Kenneth,
Congratulations on the successful completion of a support session at Online Support.
Session ID: MST-283193
Date of Session: Tuesday Dec 11 2012
Customer Name: Mich
In addition to the Session Report that you completed at the end of the session, we ask that you complete a Solution Report as well.
Hi, making a macro for this is very simple I can set up your Outlook via remote control and create the code there.
Another option is to make a small application that monitors outlook (if you don't want to mess with outlook) but this one will take a little longer.
$40 USD v 1 dni
5,0 (1 recenze)
3,0
3,0
3 freelanceři nabízejí v průměru $63 USD za tuto práci
VBA developer since 1997. Looking at the sample email, I'd say this can be done without regex. Which makes the task much simpler. Can do. Regards, Svet.