• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

MailEnvelope error

Svmaxcel

Member
I ran below code and got error method mailenvelope of object _worksheet failed
Code:
Sub test1 ()
Range("A1").Select
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope.item
  .Introduction = ""
  .Item.To = ABC@BBC.com
  .Item.CC = ""
  .Item.Subject = Subject
  .Item.Send
End With
End Sub
 
I tried to create outlook object to send email, but in that case inserting the data table would be a challenge, so I thought of using mailenvelope what's wrong in my code
 
Back
Top