email
 

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

email
 

Hi Greg

Start here
http://www.rondebruin.nl/sendmail.htm


Try this one first
http://www.rondebruin.nl/mail/folder1/mail2.htm




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Greg B" <littlelap(no wrote in message ...
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

email
 

Thank you works great

Greg B
"Ron de Bruin" wrote in message
...
Hi Greg

Start here
http://www.rondebruin.nl/sendmail.htm


Try this one first
http://www.rondebruin.nl/mail/folder1/mail2.htm




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Greg B" <littlelap(no wrote in message
...
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