Sending email: Warning message

[RPrasad]

Hi,
When I use the below code

DoCmd.SendObject acTable, "Travel_Oputput", "MicrosoftExcelBiff8(*.xls)", "RP@gmail.com", "", "", "Test", "", False, ""

It always displyas a message "A programme is trying to automatically send e-mail on your behalf. Do you want to allow this?"

Is there a way to avoid this message? when i loop through this with 25 email ID's i need to click "yes" 25 times. Please help.

Thank you

 

[RCMetrics]

I use a program called "click yes"

it does it on your behalf.

I beleive I saw some code to overcome that outlook security patch but not sure where.

your quickest and easiest way would be this program.

http://www.contextmagic.com/express-clickyes/

Bye bye

 

[RPrasad]

Thank you RCmetrics, this helps. moreover it offers facility of activating and deactivating as per our requirement