So you're asking about how to set up an email in Access?
this code will do what you want you just have to modify things to fit your particular database particularly if you're cycling through a lot of records:
Code:
Dim objOutl
Set objOutl = CreateObject("Outlook.Application")
Set objMailItem = objOutl.CreateItem(olMailItem)
'comment the next line if you do not want to see the outlook window
objMailItem.Display
strEmailAddr = "<email list as a string>"
objMailItem.Recipients.Add strEmailAddr
objMailItem.Body = "<body>"
objMailItem.Attachments.Add "<path and file name>"
objMailItem.Send
Set objMailItem = nothing
Set objOutl = nothing
NOTE: I would strongly recommend you not store documents in Access, it will make your file blow up very quickly (size wise). What I'd do instead is just store the path where the file is stored, this not only saves room but would also make this code very easy to run.
Windows XP 
Access 2007
Reply With Quote
