Contributors in 1999 were Andrew Perrin, Eric June of Intuitive Data and Dev Ashish. 

Various Tips

• Sample Code illustrating looping through a DAO recordset so you can send an email to each email address on a record using a query
• Creating a formatted document in an email from Microsoft Access
• You can also use Stephen Leban's HTML Editor to send HTML formatted emails.  However you must ensure that your email sending program supports HTML formatted emails.    ( 2003-12-14)  
• Emailing reports as attachments such as Snapshot, PDF or RTF format.
• EmailSenate and EmailSenate2K demonstrate sending multiple reports to multiple recipients
• Bug: Hyperlink with "mailto:" tag opens two windows
• Note: Send a report via Email
• Note: Email/Export Charts from Access
• Bug: ACC2000: SendObject Method Fails in Access 2000 - 260819
• Emailing a different report to each recipient
• Inserting data from incoming emails created by a website into tables
• Reading Outlook E-Mails from Microsoft Access
• Personalized Email from Access and Word   
• Example Code for sending mail from Excel   ( 2004-11-08)

Choosing a method of sending your email.

I would prefer Directly via the Winsock as this option avoids the distribution problems of DLLs or OCXs.

Third Party Controls comes in second given the Microsoft DLL/OCX version problems.

The above two solutions allow your program to receive and monitor some error messages much closer.  For example the your email server would inform your software that a given domain name doesn't exist.   However these solutions require a lot more familiarity with VBA code.

Note that with any solution you would likely want to use a dedicated email account as the Reply-To address.  Thus either the users or, where feasible, your software can handle the various inquiries and inevitable bounces.

• SendObject
• MAPI and Outlook Express
• Outlook
• CDO aka CDONTS
• Automation against your favourite email application - Use direct object manipulation of your favourite email application.
          - Eudora does this okay (it exposes a set of classes you can use to manipulate the program). 
          - Pegasus only supports Simple MAPI, MAPI 1.0 and DDE. (But this was as of 1999.)
• Using an IIS Server
• Shell-based (DOS) mailer
• Lotus Notes
• Novell GroupWise

Odds and Sods

• RFC2822 - Internet Message Format "Internet Official Protocol Standards" describing email.