Outlook From Access Class Module Demo |
Post Reply |
Author | |
Randy Schnoes
Contributor Joined: 30 Jun 2008 Status: Offline Points: 3 |
Post Options
Thanks(0)
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
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Randy Schnoes
Contributor Joined: 30 Jun 2008 Status: Offline Points: 3 |
Post Options
Thanks(0)
|
My email address in the original post was an old one. My current email address is randy.schnoes@columbiamanagement.com. |
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |