View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Ho Paul Ho is offline
external usenet poster
 
Posts: 5
Default Email selected range in Excel

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