One button, two functions? Excel

[cantona_007]

So I have a macro button in my worksheet that sends a specific range of cells as an email, I also have another button that resets the fields of those cells when the email has been sent. I was wondering if there’s a way I could combine those two functions to just one button. So in essence, I want to be able to just click the one button and it’ll send the email, as well as reset the cells.</SPAN>
I've tried everything i know with VBA codes but, no luck!

Is this even possible?... thanks for your help.</SPAN>
Cheers!</SPAN>

 

[GRTorres]

Hello cantona_007,

Yes, this is possible. It just all depends on the order / the way you choose to nest your lines of code. For instance:

Sub EmailRange()

ActiveSheet.Range("A1").Select
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
  .Item.To = johnsmith@yahoo.com
  .Item.Subject = "Test"
  .Item.Send
End With

'place remainder of your code here

End Sub

The action above will select a range and then e-mail out the specs.

You will want to substitute in your code after the send function has released.

Hope this makes sense.