By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,056 Members | 1,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,056 IT Pros & Developers. It's quick & easy.

Send email automatically using SendObject

100+
P: 121
Hi

I am using the following code to send an email from access via outlook automatically

Expand|Select|Wrap|Line Numbers
  1.  
  2. DoCmd.SendObject acSendReport, stDocName, acFormatRTF, "User", , , , , False
  3.  
  4.  
Which works fine but i get an outlook error message which says

"A program is trying to send an email message on your behalf. if this is unexpected .... Blah Blah Blah

Allow Deny Help

is there anyway that i can avoid this message and send the email without verification?

Regards Phill
Feb 2 '09 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 1,287
If using Outlook 2007, you may be able to change the Programmatic Access setting under Tools -> Trust Center.
I'm not sure where this is located in previous versions.
Feb 2 '09 #2

Expert Mod 2.5K+
P: 2,545
Hi. The Outlook message is intended to warn you that it is being used to send a message under programme control - guarding against spamming uses for example. I don't think you can stop Outlook from asking for this kind of confirmation; however software solutions such as ClickYes can automate the sending of the confirmation keypress for you and allow fully unattended e-mails to be sent from Access via Outlook.

There are paid-for and free versions of ClickYes available (I have the free version, Express QuickYes, installed myself and although there are some limitations it does the job well enough). If you are interested the vendor's website is http://www.contextmagic.com/express-clickyes/. No doubt there are similar solutions available from other vendors, which some searching on Google may reveal.

-Stewart
Feb 2 '09 #3

100+
P: 121
Hi Stewart apologies for the late reply i have been away

Thanks for your help

Phill
Feb 19 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.