Hi all,

I am wondering how I can email a sheet from my workbook to an address when a
button is clicked.
The sheet name is "Statement"
I need the subject to be "Weekly Account"
sent to a certain email address as well

I am looking up different pages but not sure which one will help in my case.

Thanks in advance

Greg B