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-Componen ts-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" J since 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.
<<image001.gif>>
