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