Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bypass: A program is trying to send mail using Item.Send prompt | Excel Discussion (Misc queries) | |||
How do I send a xl-sheet as a mail using a VBA-script? | Excel Programming | |||
cannot send excel worksheet (sheet only) to mail recipient | Excel Discussion (Misc queries) | |||
Strange request Automaticaly send spread sheet as an e-mail | Excel Programming | |||
Not using send button on excel e-mail | Excel Programming |