emailing a userform during runtime

[dstyles782001]

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

[Henrich]

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

ActiveWorkbook.SendMail Recipients:="[email protected]",
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
>
>

[Ron de Bruin]

If you only want to send one sheet

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

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


"Henrich" <[email protected]> wrote in message news:[email protected]...
> Outlook must be set as default mailing client and the code is:
>
> ActiveWorkbook.SendMail Recipients:="[email protected]",
> 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
>>
>>