DoCmd.SendObject should work if Outlook Express is set as the default mail client. This
command allows you to programmatically add a file attachment, such as a report snapshot or
rich text file.
If you want to avoid Outlook and Outlook Express all together, you can use a product such
as ASPmail or ASPQmail (queued mail). I think this works with Access, although I'm not
positive. Worldcast (
http://www.fairlogic.com/worldcast/index.shtml) offers an e-mail
blaster that is free for non-commercial use. FMS offers Total Access E-mailer
(
http://www.fmsinc.com/products/Emailer/index.asp) but this is definitely not free.
____________________________________
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:Zi**********************@newssvr28.news.prodi gy.com...
I'm using the CreateObject method to send email from Access.
Set objOutlook = CreateObject("Outlook.Application")
This, of course, launches Outlook to send the message. Anyone know if there
is a way to do the same sort of thing but have it launch Outlook Express
instead of Outlook?