how to email reports - revisted

[Rover]

I can now email reports via Outlook but How do I do it via Outlook Express?

I got this piece of code from this newsgroup to send reports via Outlook.
===============================
Set objOutlook = CreateObject("Outlook.application")
Set objEmail = objOutlook.CreateItem(olMailItem)

With objEmail
.To = "(e-mail address removed)"
.Subject = "Sample Reports"
.body = "Type message here"
.Attachments.Add "C:\report1.snp"
.attachments.Add "C:\report2.snp"
.Send
'.ReadReceiptRequested
End With
======================

My client is using Outlook Express. I tried:
Set objOutlook = CreateObject("OutlookExpress.application")
but it didn't like it at all. I can have this one machine set up for
Outlook but I'd rather not. Any one know how to do this?

tia

Jim

 

[Douglas J. Steele]

You can't do the equivalent using Outlook Express: it doesn't expose itself
for automation like Outlook does.

Take a look at what Tony Toews has at
http://www.granite.ab.ca/access/email.htm to see some options, including the
SendObject method.