You can't suppress this from VBA, it's there for precisely that purpose

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"sri" wrote in message
...
Hi,

I have written a macro in the excel to select the list of mailids to send
mail.When i was trying to execute the macro, it is asking' A program is
trying to access the mail address in the outlook. do you want to allow
this'.

i want to suppress this message.

thanks