I have successfully circumvented this "feature" of Exchange by using a combination of an Access VB project and Outlook Redemption<http://www.dimastr.com/redemption/>. I was told this forced dialog box was added to Exchange to prevent bulk spamming. Obviously it works because we all know that spam is now a thing of the past :p
~Peter On 9/28/07, Scott Ahlbrandt <[EMAIL PROTECTED]> wrote: > > This is a little snapshot if your exchange server has a certain patch. > Thank you Thomas > > > > > > > > > > > ------------------------------ > > *From:* [EMAIL PROTECTED] [mailto: > [EMAIL PROTECTED] *On Behalf Of *Thom C. Blackwell > *Sent:* Friday, September 28, 2007 6:09 AM > *To:* [email protected] > *Subject:* RE: [Talk] Vb Code for Sending a Email in Access > > > > Greetings, > > Outlook <may> pop up a security warning when sending email via its > objects. When I used code like this two years ago on my PC, I'd get a > security warning, tried it today , I didn't. Asked around to figure out why, > and evidently it has to do with the fact that we now have an Exchange > Server, and settings can be configured on said Exchange Server that prevent > the messages. > > > > I have no idea what these settings may be - I'm no email administrator, > I'm just a user J > > > > If you run into the security warnings – from what I recall – don't bother > looking for Outlook settings to prevent them – there aren't any. > > Here are alternatives that use SMTP (Simple Mail Transport Protocol) - > http://en.wikipedia.org/wiki/Simple_Mail_Transfer_Protocol > > > > A web search for SMTP and Visual Basic seems to yield pointers to examples > that use MAPI > > This one seems comprehensive. > > > > > http://www.devarticles.com/c/a/Visual-Basic/Sending-Email-With-MAPI-Components-in-Visual-Basic/ > > * * > > *If the PC has BWS installed you can make this really easy…* > > Set b = CreateObject("BostonWorkStation70.BostonWorkStation") > > 'Here leaving the "documentation in so you can see what the parameters > are… > > b.SendMail(MailTo As String, Subject As String, Message As String, [From > As String], [Attachment As String], [Server As String], [ID As String], [PWD > As String], [Port As String], [HTML As Boolean = False]) As String > > > > And of course now your Access project could also "script something" Jsince > it's got the BostonWorkStation Object in there. > > > > Regards, > > Thom > > > > Thom C. Blackwell > > Product Manager > > Boston Software Systems > > (866) 653-5105 ex 807 > > www.bossoft.com > > > > LEGAL NOTICE Unless expressly stated otherwise, this message is > confidential and may be privileged. It is intended for the addressee(s) > only. Access to this E-mail by anyone else is unauthorized. If you are not > an addressee, any disclosure or copying of the contents of this E-mail or > any action taken (or not taken) in reliance on it is unauthorized and may be > unlawful. If you are not an addressee, please inform the sender immediately, > then delete this message and empty from your trash. > > > > *From:* [EMAIL PROTECTED] [mailto: > [EMAIL PROTECTED] *On Behalf Of *Brian Stevenson > *Sent:* Friday, September 28, 2007 8:35 AM > *To:* White, Scott A; [email protected] > *Subject:* RE: [Talk] Vb Code for Sending a Email in Access > > > > It is actually very simple. I have not tried this in my BWS yet - I use > it in a divisional app I built for my organization. > > > Set myOlApp = CreateObject("Outlook.Application") > Set myitem = myOlApp.CreateItem(olMailItem) > myitem.From = <email address> > > myitem.To = <email address> > > myitem.Subject = <subject> > > myitem.Body = <body message> > > myitem.display 'Display the message for verification or whatever > and click send or automate to send > > > > I am sure there are more options than this. If you google "vb outlook" > you may find a lot more interesting code. > > > > Brian Stevenson - Systems Administrator > > University Health System - Business Information Systems > > 4502 Medical Drive > > San Antonio, Texas 78229 > > Office: (210) 358 - 9282 > > Pager: (210) 756 - 0582 > > Fax: (210) 358 - 9287 > > > > > ------------------------------ > > *From:* White, Scott A [mailto:[EMAIL PROTECTED] > *Sent:* Friday, September 28, 2007 7:27 AM > *To:* [email protected]; Brian Stevenson > *Subject:* RE: [Talk] Vb Code for Sending a Email in Access > > If interested?????? Please tell me you are kidding.... ;-} > > > > I think we're all interested in a copy of that code. This "list" rocks. > > > > Thank you. > > > > Scott > > > > > > > > > > > > > ------------------------------ > > *From:* [EMAIL PROTECTED] [mailto: > [EMAIL PROTECTED] *On Behalf Of *Brian Stevenson > *Sent:* Friday, September 28, 2007 7:53 AM > *To:* [email protected] > *Subject:* RE: [Talk] Vb Code for Sending a Email in Access > > I can give you some vb code for opening an outlook message and sending > it???!!! if interested... > > > > Brian Stevenson - Systems Administrator > > University Health System - Business Information Systems > > 4502 Medical Drive > > San Antonio, Texas 78229 > > Office: (210) 358 - 9282 > > Pager: (210) 756 - 0582 > > Fax: (210) 358 - 9287 > > > > > ------------------------------ > > *From:* [EMAIL PROTECTED] [mailto: > [EMAIL PROTECTED] *On Behalf Of *Scott Ahlbrandt > *Sent:* Thursday, September 27, 2007 7:02 PM > *To:* [email protected] > *Subject:* [Talk] Vb Code for Sending a Email in Access > > Greetings, Does anyone have a prefab code for sending a email in vb ? I'd > like to use it as a module in Access… thanks Scotty > > > > > > > > > > Scott Ahlbrandt MCSA > > Patient Accounting Systems Analyst > > John C. Lincoln Health Network > > 250 East Dunlap > > Phoenix, Arizona 85020 > > 602-870-6060 x1286 > > http://www.jcl.com > > > > > > -------------------- > > If the reader of this message is not the intended recipient, or the employee > or agent responsible to deliver to the intended recipient, you are hereby > notified that any dissemination, distribution or copying of this > communication is strictly prohibited. If you have received this > communication in error, please immediately forward the original message back > to the sender and delete your copy of the email. > > > * > ------------------------------ > * > > *CONFIDENTIALITY NOTICE: *This e-mail communication and any attachments > may contain confidential and privileged information for the use of the > designated recipients named above. If you are not the intended > recipient, you are hereby notified that you have received this > communication in > error and that any review, disclosure, dissemination, distribution or > copying > of it or its contents is prohibited. If you have received this > communication in error, please notify Saratoga Hospital immediately by > e-mail at > [EMAIL PROTECTED] and destroy all copies of this communication > and any attachments. > > -------------------- > If the reader of this message is not the intended recipient, or the employee > or agent responsible to deliver to the intended recipient, you are hereby > notified that any dissemination, distribution or copying of this > communication is strictly prohibited. If you have received this > communication in error, please immediately forward the original message back > to the sender and delete your copy of the email. > > >
