MICROSOFT ACCESS SAMPLE WEB DATABASES CODE

This is where including yourself in the To/CC/BCC can become necessaryĪlthough the above covers most use cases, there are a number of other techniques that can be employed depending on the situation, and there are even more than the one briefly covered below.

MICROSOFT ACCESS SAMPLE WEB DATABASES CODE

Requires the developer, or user, knowledge of the server credential to be able to configure the code to function properly.Once again, even though the coding can be more complex, the function found at VBA – CDO Mail can greatly help in simplifying its implementation. In those cases where you need more power than offered by the SendObject method and your end-users don’t necessarily have Outlook as their email client, then this is where CDO Mail comes into the picture.ĬDO mail is a technique that interacts directly with the mail server and performs the send directly from there, so no email client is actually required. Automating sending the e-mail is more tricky.Requires Thunderbird be installed on the end-user’s computer.

Sent e-mails are logged in Thunderbird as a sent item.Similarly to Outlook automation, it is possible to automate Thunderbird using a function such VBA – Send E-mail Using Mozilla Thunderbird and generate HTML e-mails. Including database objects requires extra code to first export them to the hard drive before you can include them as an attachment in the emailĪs an alternative to using Microsoft Outlook, I have numerous clients using Mozilla Thunderbird as their e-mail client.Requires Outlook be installed on the end-user’s computer.This form of automation will work in any VBA application (Access, Excel, PowerPoint, Word, …).Sent e-mails are logged in Outlook as a sent item.Using a function such as the one found at VBA – Send HTML Emails Using Outlook Automation enables, IMHO, the best of both worlds! You can send emails with ease, just use the function (which requires no reference libraries), and it allows for multiple attachments, HTML content, … Pros

This is pretty much my favorite approach to sending e-mails. This method is only available in Access.Cannot include multiple database objects.Does not support HTML formatted content (no bold, italic, underlines, images, table structures, …).Sent e-mails are logged in the email client as a sent item.Can include database objects without extra code.The basic syntax isĭoCmd.SendObject( ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage, TemplateFile)Īs you can see, it even enables you to send a database object (table, query, form, report, …) in different formats (HTML, XLS(X), PDF, …). The SendObject method is a built-in technique for sending basic e-mails from Access. In this post, I’m going to briefly discuss the 3 most popular approaches:

Microsoft access sample web databases