Create a macro in outlook to check the To List in a new Mail

Hi,

I am new to macros and VB.
I have to create a macro in outlook. While sending a new mail this macro should check, whether all the recipients have gmail.com suffix.

I enabled the developer tool in Outlook and trying to write some procedure in Visual Basic to perform this action.
But the procedure is not getting visible in Macro section of Outlook.

Can anyone please suggest, the correct way of writing a macro for this.

Thanks
Rahul

Hi Nicky,
Thanks for replying.
I am getting below error, while using above code.

"Run-time error'424':
Object required"

The error is occuring in below line of code:
Set ThisItem = GetCurrentItem

Am i missing anything to include here.

Thanks
Rahul

My apologies, I included a reference to a separate macro

try this

Please Login or Register  to view this content.

Thanks Nicky, This code is able to fetch the "To list".
Now the problem is when we do a Ctrl+K, the mail id becomes a username.
Is there any way, we can fetch mail id, corresponding to the username and then check on it for gmail.com suffix.

Thanks
Rahul

Hi Rahul
this is probably a better version as it does not rely on splitting a text string to get email addresses.

Please Login or Register  to view this content.