Hello Gurus,

Need your help on the below issues which currently i am facing -

1- Whenever i run the marcro then a Popup window comes up asking me to grant permission and need to manually click on 'Yes' button again and again.
But as i have to send more than 200 mails and clicking on every time require lots of time. Is there any way i can skip this and mails directly gets shooted to the users.

2- If in email refrence column there is some data not in correct format (i.e. 88653 in place of xyz@abc.com) then it stop running the macro and sending mails.
If there any way that whatever is entered in the email refrenced column, outlook sends an email to the same and if it will bonce then let it be.

xld please help me ....need your guys valuable feedback to overcome this ...thanks for all of your time and help in advance.

Thanks,
Arun