Hi there,
Kindly advise me on how to avoid message like this: (see the attached)
I found this simple code and trying to implement in my job.
this code is working nice. However, i got a message in my outlook that ask me to choose "Yes or No" (please have a look into attachement).
What I want is let send mail and ignore outlook message.
Appreciate for your kind assistance.
Rgds, Harto
note:" I have been trap with application.displayalert = false" but doesn't work.
[VBA]Sub Emailrange()
ActiveSheet.Range("E8:J19").Select
ActiveWorkbook.EnvelopeVisible = True
Application.DisplayAlerts = False
With ActiveSheet.MailEnvelope
.Introduction = "This is a test."
.Item.To = "zzz.com"
.Item.Subject = "subject"
.Item.Send
End With
Application.DisplayAlerts = True
End Sub[/VBA]
Reply With Quote
