asked on

Disable warning message when sending email via VBA

Hi All,

I have VBA code to send an email from within Access, but I get the warning message 'A program is trying to automatically send e-mail on your behalf'

Is there anyway to disable this? The database will be used by multiple users so any third party software installed on my machine does not solve the problem for other users.

Thanks,
Dean

xmlmagician

If you use macro:
Setwarnings false

In VB:
Docmd.Setwarnings False

xmlmagician

or look in here:

http://www.granite.ab.ca/access/email.htm

ASKER CERTIFIED SOLUTION

Patrick Matthews

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

xmlmagician

if they do not work there are 3rd party tools that automatically can click yes for you

SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

deanlee17

ASKER

Hi guys,

Thanks for all the replys. Matthewspatrick: what is the CDO technique then? I want to avoid third party software as it was my understanding i would have to go round and install it on each machine?

Thanks,
Dean

deanlee17

ASKER

Ah thanks cap, didnt see your link before i posted....

Rey Obrero (Capricorn1)

if you are using A2007, you need to download CDO
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=2714320d-c997-4de1-986f-24f081725d36&DisplayLang=en

xmlmagician

@matthewspatrick it was not mentioned in the original question anywhere so i thought that might do it. As long as Dean gets some help is all good :)

deanlee17

ASKER

No cap, Access 2003.

deanlee17

ASKER

Thanks Guys