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.
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
CONFIDENTIALITY NOTICE: This communication is intended only for the use of the
individual or entity to which it is addressed and may contain information that
is privileged, confidential, and exempt from disclosure under applicable law.
If you are not the intended recipient, you are notified that any use,
dissemination, forwarding, distribution, or copying of the communication is
strictly prohibited. Please notify the sender immediately by e-mail if you
have received this by mistake and delete this e-mail from your system.
(University Health System)
</STRONG></P></BODY></HTML><<image001.gif>>
BEGIN:VCARD VERSION:2.1 N:Stevenson;Brian FN:Brian Stevenson ORG:University Health System;Business Information Systems TITLE:Systems Administrator TEL;WORK;VOICE:(210) 358-9282 TEL;CELL;VOICE:(210) 410-0526 TEL;PAGER;VOICE:(210) 756-0582 TEL;WORK;FAX:(210) 358-9287 ADR;WORK:;Business Center;355-2 Spencer Lane;San Antonio;Texas;78201;United States of America LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Business Center=0D=0A355-2 Spencer Lane=0D=0ASan Antonio, Texas 78201=0D=0AU= nited States of America ADR;HOME:;;;;;;United States of America LABEL;HOME:United States of America ADR;POSTAL:;;;;;;United States of America LABEL;POSTAL:United States of America URL;WORK:http://www.universityhealthsystem.com EMAIL;PREF;EX:/o=UHS/ou=First Administrative Group/cn=Recipients/cn=BLS90720 REV:20070328T174621Z END:VCARD
