Email selected range in Excel

P

Paul Ho

Hi,
I send out the range with below code. But when I read the email, the
problem are 1. the content shifted to the middle 2. The email background
color auto changed to green (default should be white color). Anybody can
help? Thanks.

Sub Send_Range()
With ActiveSheet.MailEnvelope
.Introduction = "This is a sample worksheet."
.Item.To = "E-Mail_Address_Here"
.Item.Subject = "My subject"
.Item.Send
End With
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top