Need help on Outlook 2010 Macro

[rainpuppy]

Hi Guys,

I am a noob with outlook macro and been toiling around the internet helplessly for some assistance on a macro.



I am looking for a macro in outlook 2010, which will get trigger whenever an email is being reply by a user with a shared mailbox. The macro will perform the below steps

1.“Lock” the email so that other users is not able to reply to the email
2.Scan subject header for a unique reference in the format of CASEDDMMMYYHHMMSSXXX
·Where “CASE” is fixed
·“DDMMMYY” follow the date format - DD and YY in number and MMM in aphabet
·“HHMMSS” follow the 24 hour time format
·“XXX” denote the number of character on the original subject header
3.If this reference is available, no changes is required. Original email will be moved to a preset folder after email is sent
4.If this reference is not available, append the unique reference at the end of the subject header*. Original email with new subject header will be moved to a preset folder after email is sent

*for example, if the original email subject is “URGENT – Need your Response ASAP”, the macro will change the subject header to “URGENT – Need your Response ASAP – CS01FEB13223763032”

Appreciate any help i can get!