| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
email forms
how can i send an excel form directly to an email i am using vista
-- alexanderd |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email forms
Hi Alexanderd, have a look on this site...
http://www.rondebruin.nl/mail/add-in.htm Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email forms
hi les thank you for the quick reply.
i had already found the page, but from what i see it will email the whole book or a page what i want to do is just send the form infront of the excel page. is this possibel?? -- alexanderd "Les Stout" wrote: Hi Alexanderd, have a look on this site... http://www.rondebruin.nl/mail/add-in.htm Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email forms
Hi alexanderd
There is a example that send a range also on my page (Body and attachment) Which mail program do you use ? Do you want to send in the body or as attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi les thank you for the quick reply. i had already found the page, but from what i see it will email the whole book or a page what i want to do is just send the form infront of the excel page. is this possibel?? -- alexanderd "Les Stout" wrote: Hi Alexanderd, have a look on this site... http://www.rondebruin.nl/mail/add-in.htm Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email forms
hi ron thank you for your reply (and all the help you have been in the past)
whilst at home i have vista i will save it for use with windows 2003 and outlook. what i was hoping to do was place a button on the form and use it to send the email from. it would be grate if it could be done. -- alexanderd "Ron de Bruin" wrote: Hi alexanderd There is a example that send a range also on my page (Body and attachment) Which mail program do you use ? Do you want to send in the body or as attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi les thank you for the quick reply. i had already found the page, but from what i see it will email the whole book or a page what i want to do is just send the form infront of the excel page. is this possibel?? -- alexanderd "Les Stout" wrote: Hi Alexanderd, have a look on this site... http://www.rondebruin.nl/mail/add-in.htm Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email forms
What do you mean with form ?
Range on a sheet or a userform ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi ron thank you for your reply (and all the help you have been in the past) whilst at home i have vista i will save it for use with windows 2003 and outlook. what i was hoping to do was place a button on the form and use it to send the email from. it would be grate if it could be done. -- alexanderd "Ron de Bruin" wrote: Hi alexanderd There is a example that send a range also on my page (Body and attachment) Which mail program do you use ? Do you want to send in the body or as attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi les thank you for the quick reply. i had already found the page, but from what i see it will email the whole book or a page what i want to do is just send the form infront of the excel page. is this possibel?? -- alexanderd "Les Stout" wrote: Hi Alexanderd, have a look on this site... http://www.rondebruin.nl/mail/add-in.htm Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email forms
i would like to send a copy of the userform with the email not the excel sheet
-- alexanderd "Ron de Bruin" wrote: What do you mean with form ? Range on a sheet or a userform ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi ron thank you for your reply (and all the help you have been in the past) whilst at home i have vista i will save it for use with windows 2003 and outlook. what i was hoping to do was place a button on the form and use it to send the email from. it would be grate if it could be done. -- alexanderd "Ron de Bruin" wrote: Hi alexanderd There is a example that send a range also on my page (Body and attachment) Which mail program do you use ? Do you want to send in the body or as attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi les thank you for the quick reply. i had already found the page, but from what i see it will email the whole book or a page what i want to do is just send the form infront of the excel page. is this possibel?? -- alexanderd "Les Stout" wrote: Hi Alexanderd, have a look on this site... http://www.rondebruin.nl/mail/add-in.htm Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email forms
Body or attachment ?
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... i would like to send a copy of the userform with the email not the excel sheet -- alexanderd "Ron de Bruin" wrote: What do you mean with form ? Range on a sheet or a userform ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi ron thank you for your reply (and all the help you have been in the past) whilst at home i have vista i will save it for use with windows 2003 and outlook. what i was hoping to do was place a button on the form and use it to send the email from. it would be grate if it could be done. -- alexanderd "Ron de Bruin" wrote: Hi alexanderd There is a example that send a range also on my page (Body and attachment) Which mail program do you use ? Do you want to send in the body or as attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi les thank you for the quick reply. i had already found the page, but from what i see it will email the whole book or a page what i want to do is just send the form infront of the excel page. is this possibel?? -- alexanderd "Les Stout" wrote: Hi Alexanderd, have a look on this site... http://www.rondebruin.nl/mail/add-in.htm Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email forms
i have no preference at this point in time, i would gladly accept any way,
you were willing to suggest and help me with. alexanderd "Ron de Bruin" wrote: Body or attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... i would like to send a copy of the userform with the email not the excel sheet -- alexanderd "Ron de Bruin" wrote: What do you mean with form ? Range on a sheet or a userform ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi ron thank you for your reply (and all the help you have been in the past) whilst at home i have vista i will save it for use with windows 2003 and outlook. what i was hoping to do was place a button on the form and use it to send the email from. it would be grate if it could be done. -- alexanderd "Ron de Bruin" wrote: Hi alexanderd There is a example that send a range also on my page (Body and attachment) Which mail program do you use ? Do you want to send in the body or as attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi les thank you for the quick reply. i had already found the page, but from what i see it will email the whole book or a page what i want to do is just send the form infront of the excel page. is this possibel?? -- alexanderd "Les Stout" wrote: Hi Alexanderd, have a look on this site... http://www.rondebruin.nl/mail/add-in.htm Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email forms
If you use Alt-PrtScn on your keyboard with the userform active you have a
picture of it and can paste it in the mail Is that a option ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... i have no preference at this point in time, i would gladly accept any way, you were willing to suggest and help me with. alexanderd "Ron de Bruin" wrote: Body or attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... i would like to send a copy of the userform with the email not the excel sheet -- alexanderd "Ron de Bruin" wrote: What do you mean with form ? Range on a sheet or a userform ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi ron thank you for your reply (and all the help you have been in the past) whilst at home i have vista i will save it for use with windows 2003 and outlook. what i was hoping to do was place a button on the form and use it to send the email from. it would be grate if it could be done. -- alexanderd "Ron de Bruin" wrote: Hi alexanderd There is a example that send a range also on my page (Body and attachment) Which mail program do you use ? Do you want to send in the body or as attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi les thank you for the quick reply. i had already found the page, but from what i see it will email the whole book or a page what i want to do is just send the form infront of the excel page. is this possibel?? -- alexanderd "Les Stout" wrote: Hi Alexanderd, have a look on this site... http://www.rondebruin.nl/mail/add-in.htm Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email forms
it is an option but as other people less pc minded than myself. i would rater
say press button "A" -- alexanderd "Ron de Bruin" wrote: If you use Alt-PrtScn on your keyboard with the userform active you have a picture of it and can paste it in the mail Is that a option ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... i have no preference at this point in time, i would gladly accept any way, you were willing to suggest and help me with. alexanderd "Ron de Bruin" wrote: Body or attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... i would like to send a copy of the userform with the email not the excel sheet -- alexanderd "Ron de Bruin" wrote: What do you mean with form ? Range on a sheet or a userform ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi ron thank you for your reply (and all the help you have been in the past) whilst at home i have vista i will save it for use with windows 2003 and outlook. what i was hoping to do was place a button on the form and use it to send the email from. it would be grate if it could be done. -- alexanderd "Ron de Bruin" wrote: Hi alexanderd There is a example that send a range also on my page (Body and attachment) Which mail program do you use ? Do you want to send in the body or as attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi les thank you for the quick reply. i had already found the page, but from what i see it will email the whole book or a page what i want to do is just send the form infront of the excel page. is this possibel?? -- alexanderd "Les Stout" wrote: Hi Alexanderd, have a look on this site... http://www.rondebruin.nl/mail/add-in.htm Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email forms
Hi alexanderd
Is also possible with code Bedtime for me now, will post a example tomorrow after work Do you use Outlook ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... it is an option but as other people less pc minded than myself. i would rater say press button "A" -- alexanderd "Ron de Bruin" wrote: If you use Alt-PrtScn on your keyboard with the userform active you have a picture of it and can paste it in the mail Is that a option ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... i have no preference at this point in time, i would gladly accept any way, you were willing to suggest and help me with. alexanderd "Ron de Bruin" wrote: Body or attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... i would like to send a copy of the userform with the email not the excel sheet -- alexanderd "Ron de Bruin" wrote: What do you mean with form ? Range on a sheet or a userform ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi ron thank you for your reply (and all the help you have been in the past) whilst at home i have vista i will save it for use with windows 2003 and outlook. what i was hoping to do was place a button on the form and use it to send the email from. it would be grate if it could be done. -- alexanderd "Ron de Bruin" wrote: Hi alexanderd There is a example that send a range also on my page (Body and attachment) Which mail program do you use ? Do you want to send in the body or as attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi les thank you for the quick reply. i had already found the page, but from what i see it will email the whole book or a page what i want to do is just send the form infront of the excel page. is this possibel?? -- alexanderd "Les Stout" wrote: Hi Alexanderd, have a look on this site... http://www.rondebruin.nl/mail/add-in.htm Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email forms
have a good nights sleep ,
yes i do use outlook -- alexanderd "Ron de Bruin" wrote: Hi alexanderd Is also possible with code Bedtime for me now, will post a example tomorrow after work Do you use Outlook ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... it is an option but as other people less pc minded than myself. i would rater say press button "A" -- alexanderd "Ron de Bruin" wrote: If you use Alt-PrtScn on your keyboard with the userform active you have a picture of it and can paste it in the mail Is that a option ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... i have no preference at this point in time, i would gladly accept any way, you were willing to suggest and help me with. alexanderd "Ron de Bruin" wrote: Body or attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... i would like to send a copy of the userform with the email not the excel sheet -- alexanderd "Ron de Bruin" wrote: What do you mean with form ? Range on a sheet or a userform ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi ron thank you for your reply (and all the help you have been in the past) whilst at home i have vista i will save it for use with windows 2003 and outlook. what i was hoping to do was place a button on the form and use it to send the email from. it would be grate if it could be done. -- alexanderd "Ron de Bruin" wrote: Hi alexanderd There is a example that send a range also on my page (Body and attachment) Which mail program do you use ? Do you want to send in the body or as attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi les thank you for the quick reply. i had already found the page, but from what i see it will email the whole book or a page what i want to do is just send the form infront of the excel page. is this possibel?? -- alexanderd "Les Stout" wrote: Hi Alexanderd, have a look on this site... http://www.rondebruin.nl/mail/add-in.htm Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#14
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email forms
yes i do use oulook ref vista buisness
-- alexanderd "Ron de Bruin" wrote: Hi alexanderd Is also possible with code Bedtime for me now, will post a example tomorrow after work Do you use Outlook ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... it is an option but as other people less pc minded than myself. i would rater say press button "A" -- alexanderd "Ron de Bruin" wrote: If you use Alt-PrtScn on your keyboard with the userform active you have a picture of it and can paste it in the mail Is that a option ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... i have no preference at this point in time, i would gladly accept any way, you were willing to suggest and help me with. alexanderd "Ron de Bruin" wrote: Body or attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... i would like to send a copy of the userform with the email not the excel sheet -- alexanderd "Ron de Bruin" wrote: What do you mean with form ? Range on a sheet or a userform ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi ron thank you for your reply (and all the help you have been in the past) whilst at home i have vista i will save it for use with windows 2003 and outlook. what i was hoping to do was place a button on the form and use it to send the email from. it would be grate if it could be done. -- alexanderd "Ron de Bruin" wrote: Hi alexanderd There is a example that send a range also on my page (Body and attachment) Which mail program do you use ? Do you want to send in the body or as attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi les thank you for the quick reply. i had already found the page, but from what i see it will email the whole book or a page what i want to do is just send the form infront of the excel page. is this possibel?? -- alexanderd "Les Stout" wrote: Hi Alexanderd, have a look on this site... http://www.rondebruin.nl/mail/add-in.htm Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#15
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email forms
My idea is not working Alex.
Can't you add the values of the textboxes on cells in a worksheet and send that ? You can run this with the send button in the userform Sheets("Sheet1").Range("A1").Value = Me.Textbox1.text ect -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... yes i do use oulook ref vista buisness -- alexanderd "Ron de Bruin" wrote: Hi alexanderd Is also possible with code Bedtime for me now, will post a example tomorrow after work Do you use Outlook ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... it is an option but as other people less pc minded than myself. i would rater say press button "A" -- alexanderd "Ron de Bruin" wrote: If you use Alt-PrtScn on your keyboard with the userform active you have a picture of it and can paste it in the mail Is that a option ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... i have no preference at this point in time, i would gladly accept any way, you were willing to suggest and help me with. alexanderd "Ron de Bruin" wrote: Body or attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... i would like to send a copy of the userform with the email not the excel sheet -- alexanderd "Ron de Bruin" wrote: What do you mean with form ? Range on a sheet or a userform ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi ron thank you for your reply (and all the help you have been in the past) whilst at home i have vista i will save it for use with windows 2003 and outlook. what i was hoping to do was place a button on the form and use it to send the email from. it would be grate if it could be done. -- alexanderd "Ron de Bruin" wrote: Hi alexanderd There is a example that send a range also on my page (Body and attachment) Which mail program do you use ? Do you want to send in the body or as attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi les thank you for the quick reply. i had already found the page, but from what i see it will email the whole book or a page what i want to do is just send the form infront of the excel page. is this possibel?? -- alexanderd "Les Stout" wrote: Hi Alexanderd, have a look on this site... http://www.rondebruin.nl/mail/add-in.htm Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
|
#16
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
email forms
a good idea i will work on that .
thank you for all your help with this -- alexanderd "Ron de Bruin" wrote: My idea is not working Alex. Can't you add the values of the textboxes on cells in a worksheet and send that ? You can run this with the send button in the userform Sheets("Sheet1").Range("A1").Value = Me.Textbox1.text ect -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... yes i do use oulook ref vista buisness -- alexanderd "Ron de Bruin" wrote: Hi alexanderd Is also possible with code Bedtime for me now, will post a example tomorrow after work Do you use Outlook ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... it is an option but as other people less pc minded than myself. i would rater say press button "A" -- alexanderd "Ron de Bruin" wrote: If you use Alt-PrtScn on your keyboard with the userform active you have a picture of it and can paste it in the mail Is that a option ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... i have no preference at this point in time, i would gladly accept any way, you were willing to suggest and help me with. alexanderd "Ron de Bruin" wrote: Body or attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... i would like to send a copy of the userform with the email not the excel sheet -- alexanderd "Ron de Bruin" wrote: What do you mean with form ? Range on a sheet or a userform ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi ron thank you for your reply (and all the help you have been in the past) whilst at home i have vista i will save it for use with windows 2003 and outlook. what i was hoping to do was place a button on the form and use it to send the email from. it would be grate if it could be done. -- alexanderd "Ron de Bruin" wrote: Hi alexanderd There is a example that send a range also on my page (Body and attachment) Which mail program do you use ? Do you want to send in the body or as attachment ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "alexanderd" wrote in message ... hi les thank you for the quick reply. i had already found the page, but from what i see it will email the whole book or a page what i want to do is just send the form infront of the excel page. is this possibel?? -- alexanderd "Les Stout" wrote: Hi Alexanderd, have a look on this site... http://www.rondebruin.nl/mail/add-in.htm Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel forms - authorise / deny forms | Excel Programming | |||
| Email, forms, Excel, Infopath, Sharepoint | Excel Discussion (Misc queries) | |||
| email forms | Excel Programming | |||
| Calling Forms from Forms - Exit problems | Excel Programming | |||
| Using Excel / VBA to automatically email forms - how? | Excel Programming | |||
![alexanderd[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
