Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

what error?!

Status
Not open for further replies.

jonra

Programmer
Jul 20, 2003
42
SG
"class does not support automation or does not support expected interface"...what is tis error?...

tis is my code

Public Sub sentMail()
Dim objOutlook As New Outlook.Application
Dim objMessage As MailItem
Set objOutlook = CreateObject("Outlook.Application")
Set objMessage = objOutlook.CreateItem(olMailItem)
With objMessage
.To = "xxx@hotmail.com"
.Subject = "Report"
.Body = "test"
.Attachments.Add "C:\Report.doc"
.Send
End With
Set objOutlook = Nothing
Set objMessage = Nothing
end sub
 
try searching for error 430 in the VBA forum, and look at

mstrmage1768 'Email attachment' on 29 May 03 - that seems to be the same problem.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top