email Button

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BadRasta! - 09 May 2008 17:40 GMT

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 123@4567.com
Button 2 pressed send current worksheet to address 321@7654.com

& so on

Thnx,
BadRasta

Reply to this Message

Reitanos - 09 May 2008 19:28 GMT

You could use a macro with the following line:
ActiveWorkbook.SendMail Recipients:="a@b.com"

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! <BadRa...@discussions.microsoft.com>
wrote:

> Hello All,
> I'm trying to create a button that when pressed it sends an email to a
[quoted text clipped - 7 lines]
> Thnx,
> BadRasta

Reply to this Message

Jasfoster - 14 May 2008 03:27 GMT

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

> You could use a macro with the following line:
> ActiveWorkbook.SendMail Recipients:="a@b.com"
[quoted text clipped - 19 lines]
> > Thnx,
> > BadRasta

Reply to this Message

Ron de Bruin - 09 May 2008 20:44 GMT

Hi BadRasta

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

Signature

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

> Hello All,
> I'm trying to create a button that when pressed it sends an email to a
[quoted text clipped - 7 lines]
> Thnx,
> BadRasta

Reply to this Message