email Button
 

Hello All,
I'm trying to create a button that when pressed it sends an email to a
specific email address.
That is...
Button 1 pressed send current worksheet to address
Button 2 pressed send current worksheet to address

& so on

Thnx,
BadRasta

email Button
 

You could use a macro with the following line:
ActiveWorkbook.SendMail "

Excel will attempt to send it using the default mail client (if there
is one) and give the message a subject that is the document name.
You could create the button with the Forms toolbar and assign your
macro to it.

There's probably a way to force a custom subject line - anyone know?

On May 9, 12:40 pm, BadRasta!
wrote:
Hello All,
I'm trying to create a button that when pressed it sends an email to a
specific email address.
That is...
Button 1 pressed send current worksheet to address
Button 2 pressed send current worksheet to address

& so on

Thnx,
BadRasta

email Button
 

Hi BadRasta

See this page
http://www.rondebruin.nl/sendmail.htm

--

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


"BadRasta!" wrote in message ...
Hello All,
I'm trying to create a button that when pressed it sends an email to a
specific email address.
That is...
Button 1 pressed send current worksheet to address
Button 2 pressed send current worksheet to address

& so on

Thnx,
BadRasta

email Button
 

Is there a way to record the Macro with a line just to send a single sheet
not the entire workbook?

"Reitanos" wrote:

You could use a macro with the following line:
ActiveWorkbook.SendMail "

Excel will attempt to send it using the default mail client (if there
is one) and give the message a subject that is the document name.
You could create the button with the Forms toolbar and assign your
macro to it.

There's probably a way to force a custom subject line - anyone know?

On May 9, 12:40 pm, BadRasta!
wrote:
Hello All,
I'm trying to create a button that when pressed it sends an email to a
specific email address.
That is...
Button 1 pressed send current worksheet to address
Button 2 pressed send current worksheet to address

& so on

Thnx,
BadRasta