ActiveWorkbook.EnvelopeVisible = True
.Introduction = "This is a sample worksheet."
.Item.To = "email@example.com"
.Item.Subject = "My subject"
I am using the above code. Unfortunately there are no alternative due to the fact I must keep the formatting of the sheet alive.
Now this code works except I get a msg saying 'a program is trying to send email on your behalf..."
How do I supress this? (the method has to work in other computers as well - I cannot download a plugin, etc)
Any help is appreciated