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
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
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
>
>
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
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks