I have created a protected form that needs to be sent to a large community.
I would like to have a "button" placed on the form that will save the form
and them email it it to specific users using the filename as the subject line.
Thanks!
Hi, John. Try this (uses default email client):
http://www.vbaexpress.com/kb/getarticle.php?kb_id=310
or this (uses Outlook only):
http://www.vbaexpress.com/kb/getarticle.php?kb_id=98
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
> I have created a protected form that needs to be sent to a large community.
> I would like to have a "button" placed on the form that will save the form
> and them email it it to specific users using the filename as the subject line.
>
> Thanks!