Send MailEnvelope from other sheet

[marcoVera]

Hello, I want to send an email from other sheet.
Example I'm in Sheet1 and I want to send the info of the Sheet2

With Sheet2.MailEnvelope
.Introduction = "Created Accounts"
.Item.To = marco@mail.com
.Item.Subject = "Created accounts"
.Item.Send
End With

If I use this code it send the infor of the sheet1 :S why?

 

[wigi]

Marco

You first need to activate the other sheet, after that do the MailEnvelope code.

 

[marcoVera]

Marco

You first need to activate the other sheet, after that do the MailEnvelope code.

Thanks! How can I activate it?

 

[wigi]

Sheet2.Activate

 

[marcoVera]

Sheet2.Activate

You are right!, thanks