Hi All,

I am new to OUTLOOK VBA's. I have tried reading some websites to learn VBA for outlook. But, I need help beyond my learn which I am unable to. I would really appreciate if anyone help me on this. This will help to avoid risk in my work.

I need a macro for outlook 2007/2010 which VBA should not allow to send a mail if mail content does not meet the below criteria.
Better I will explain my criteria with one example which helps to understand well.
Example:
If I want to send an email to client with an attachment.
Email id: [email protected] (Assume XYZ is my client).
Attachment name: Outstanding-XYZ 2014
EMail Subject: List of Outstandings for XYZ 2013-2014
Body of message: Please find the update on outstandings for XYZ for the period 2014. (Somewhere in the body my client will be there)

If mail consists of my client name(XYZ) in Email id, Attachment name, EMail SUbject, Body of the message only the mail should trigger to send. Otherwise outlook need to show an error message like "Incorrect email please verify"

Hope everyone understood my example. If any queries please let me know for clarification.

By using this VBA, It can avoid sharing a confidential information to other firms which we can mitigate the risk in my work.

Thanks in advance!!