Print Page | Close Window

Outlook From Access Class Module Demo

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Schnoes, Randy
Forum Description: Randy Schnoes's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=571
Printed Date: 16 Dec 2017 at 7:26pm


Topic: Outlook From Access Class Module Demo
Posted By: Randy Schnoes
Subject: Outlook From Access Class Module Demo
Date Posted: 31 Aug 2011 at 1:32pm
This demo database shows how a class module can be used to send an email from Access using Outlook.
 
The initial form has many options you can turn on or off to select or de-select or otherwise influence what's in the generated email.  Play with it and see what's possible.
 
The class module is a replacement for a similar one we used to write Lotus Notes memos from Access.  That is why you see references to Notes if you look at the code.  It also influences some of the design choices, since the point was to permit a simple swap out when we migrated to Outlook.
 
To use this, be sure the following References are set:  Visual Basic for Applications, Microsoft Access 12.0 Object Library, OLE Automation, Microsoft DAO 3.6 Object Library, Microsoft Outlook 12.0 Object Library.  Perhaps some of these are not really needed.
 
The application generates an HTML-based Outlook email.  Much of the processing relates to setting and closing HTML tags.  This can get ugly, but it works!  Because it's all wrapped up in a class module, the user is shielded from all that if they don't want to see it.
 
http://www.rogersaccesslibrary.com/forum/uploads/33/EMail_From_Access_Using_Outlook_Demo.zip - uploads/33/EMail_From_Access_Using_Outlook_Demo.zip
 
The whole point of this is to demonstrate it can be done.  Use the class module in applications to create automated emails that meet your needs.  You can have file attachments, cc: and bcc:, and most of the other things that you want in typical emails.  Where the class module doesn't do what you need, goahead and modifiy it to make it better.
 
Have fun!
 
    Randy


-------------
--

Email: mailto:Randy.Schnoes@ampf.com - Randy.Schnoes@ampf.com



Replies:
Posted By: Randy Schnoes
Date Posted: 31 Aug 2011 at 1:36pm

My email address in the original post was an old one.

My current email address is mailto:randy.schnoes@columbiamanagement.com - randy.schnoes@columbiamanagement.com .



-------------
--

Email: mailto:Randy.Schnoes@ampf.com - Randy.Schnoes@ampf.com



Print Page | Close Window