Hi. This is my first post, and a bit of a noob question, so apologies. I have written a short VBA routine to send an email automatically from within Excel. However, when I run it, I need to intervene manually when a dialog box pops up warning me that "A program is trying to automatically send e-mail on your behalf - Do you want to allow this?". The options are Yes, No and Help.

I have tried Application.DisplayAlerts = False and also Application.DoCmd.SetWarnings False, but neither of these works.

Can anyone tell me please, is there another way to stop this box from raining on my parade, or perhaps to give an automatic 'Yes' response when it does?

Many thanks.

Ian.