Send mail - button on my excel sheet, need help.
 

Hi,

Im a newbie in Excel, and I dont know programming. But I have read lots of
posts about making a button on my sheet that will save the file to a new
filename and then send it to a specific email. But i just cant make it. Need
help...

My form is an order form, so when the costumer opens the form from my
website the costumer can fill out the form and hit "send" and the form will
be saved and attached in costumers default mail application with his
details.

I know about the "File-send to-mail recipient" , but I want it more easy
than this.


Can anyone give me step by step instructions on how to do this ? I know how
to make the button it self, but I need the values to put in the place where
it now says only this:

"Private Sub CommandButton1_Click()

End Sub"



Anyone ???


kind regards,

Hans Kristian, Norway.

Send mail - button on my excel sheet, need help.
 

This should help

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

"Hans Kristian Rønning" wrote:

Hi,

Im a newbie in Excel, and I dont know programming. But I have read lots of
posts about making a button on my sheet that will save the file to a new
filename and then send it to a specific email. But i just cant make it. Need
help...

My form is an order form, so when the costumer opens the form from my
website the costumer can fill out the form and hit "send" and the form will
be saved and attached in costumers default mail application with his
details.

I know about the "File-send to-mail recipient" , but I want it more easy
than this.


Can anyone give me step by step instructions on how to do this ? I know how
to make the button it self, but I need the values to put in the place where
it now says only this:

"Private Sub CommandButton1_Click()

End Sub"



Anyone ???


kind regards,

Hans Kristian, Norway.

Send mail - button on my excel sheet, need help.
 

----- Original Message -----
From: "Mike"

This should help

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


I am so newbie in this that i could not figure it out by that page.

I've read on it before you pasted it to me. But thanks anyway.

-HK

Send mail - button on my excel sheet, need help.
 

I've tried to download the "sendmail example workbook" but when i click the
send buttons in that document nothing really happends.. isnt it supposed to
open my mail app ?

Since the examples want work there is gotta be something wrong.


-HK

Send mail - button on my excel sheet, need help.
 

There where a register problem on Hans's machine
http://www.rondebruin.nl/mail/problems.htm


--

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


"Hans Kristian Rønning" wrote in message ...
I've tried to download the "sendmail example workbook" but when i click the send buttons in that document nothing really
happends.. isnt it supposed to open my mail app ?

Since the examples want work there is gotta be something wrong.


-HK