emailing a userform during runtime
 

i would like send a form ussing outlook. i created a command button send
.. what code can i insert there to have the form sent using outlook. I am
trying to accomplish this after the user completes the form.
Thanks


--
dstyles782001
------------------------------------------------------------------------
dstyles782001's Profile: http://www.excelforum.com/member.php...o&userid=31727
View this thread: http://www.excelforum.com/showthread...hreadid=518735

emailing a userform during runtime
 

Outlook must be set as default mailing client and the code is:

ActiveWorkbook.SendMail ",
Subject:="Something", ReturnReceipt:=True

€ždstyles782001" napÃ*sal (napÃ*sala):


i would like send a form ussing outlook. i created a command button send
. what code can i insert there to have the form sent using outlook. I am
trying to accomplish this after the user completes the form.
Thanks


--
dstyles782001
------------------------------------------------------------------------
dstyles782001's Profile: http://www.excelforum.com/member.php...o&userid=31727
View this thread: http://www.excelforum.com/showthread...hreadid=518735

emailing a userform during runtime
 

If you only want to send one sheet

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Henrich" wrote in message ...
Outlook must be set as default mailing client and the code is:

ActiveWorkbook.SendMail ",
Subject:="Something", ReturnReceipt:=True

"dstyles782001" napísal (napísala):


i would like send a form ussing outlook. i created a command button send
. what code can i insert there to have the form sent using outlook. I am
trying to accomplish this after the user completes the form.
Thanks


--
dstyles782001
------------------------------------------------------------------------
dstyles782001's Profile: http://www.excelforum.com/member.php...o&userid=31727
View this thread: http://www.excelforum.com/showthread...hreadid=518735