ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   email forms (https://www.excelbanter.com/excel-programming/387971-email-forms.html)

alexanderd[_9_]

email forms
 
how can i send an excel form directly to an email i am using vista
--
alexanderd

Les Stout[_2_]

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 ***

alexanderd[_9_]

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 ***


Ron de Bruin

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 ***


alexanderd[_9_]

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 ***



Ron de Bruin

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 ***



alexanderd[_9_]

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 ***




Ron de Bruin

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 ***





alexanderd[_9_]

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 ***






Ron de Bruin

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 ***







alexanderd[_9_]

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 ***








Ron de Bruin

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 ***









alexanderd[_9_]

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 ***










alexanderd[_9_]

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 ***










Ron de Bruin

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 ***











alexanderd[_9_]

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 ***













All times are GMT +1. The time now is 05:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com