Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > Access-L Developer's Libraries > Schnoes, Randy
  New Posts New Posts RSS Feed - Outlook From Access Class Module Demo
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

Outlook From Access Class Module Demo

 Post Reply Post Reply
Author
Message
Randy Schnoes View Drop Down
Contributor
Contributor


Joined: 30 Jun 2008
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote Randy Schnoes Quote  Post ReplyReply Direct Link To This Post Topic: Outlook From Access Class Module Demo
    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.
 
 
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
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
Randy Schnoes View Drop Down
Contributor
Contributor


Joined: 30 Jun 2008
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote Randy Schnoes Quote  Post ReplyReply Direct Link To This Post Posted: 31 Aug 2011 at 1:36pm

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

My current email address is randy.schnoes@columbiamanagement.com.

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.