The IDSMail component will let you send out a message with a file attachment from MS Access with just this code:
Dim idsMail as Object 
Set idsMail = CreateObject("IDSMailInterface.Server") 
idsMail.ObjectKey = "ABC123" 
idsMail.MailSystem =IDSM_SYS_SMTP_POP 
idsMail.SMTPServer = "myprovider.com" 
idsMail.NewMessage 
idsMail.From = "MyName <me@mycompany.com>" 
idsMail.AddRecipientTo "Jim Smith <jsmith@example.com>"
idsMail.AddRecipientCc "Mary Brown <mary@example.gov>"
idsMail.Subject = "Meeting Agenda" 
idsMail.Message = "Here is the agenda for the weekly meeting."
idsMail.AddAttachment "C:\MEETINGS\AGENDA.DOC" 
idsMail.Send