I have a spreadsheet in which I have added a hyperlink to email to specific destination with a specific subject. The only thing I have not been able to do, and I have searched high and low, is attach the spreadsheet that has the hyperlink to the email. I want staff to complete certain fields within this spreadsheet, then hit "SUBMIT" and the spreadsheet be sent to one destination email address. Is this possible?
Create a Hyperlink to email the current spreadsheet
- Thread starter TONYA
- Start date
RobSA
Member
Hi Tonya,
I am also not sure if it is possible but perhaps the option of submitting the completed data in th eform to a data base is an option.
Then retracting the data can be by a process of you accessing the database.
You then dont get to see all the emails but the dat is captured anyway.
Just an Idea.
I too would be keen to see the responses on your post
I am also not sure if it is possible but perhaps the option of submitting the completed data in th eform to a data base is an option.
Then retracting the data can be by a process of you accessing the database.
You then dont get to see all the emails but the dat is captured anyway.
Just an Idea.
I too would be keen to see the responses on your post
SirJB7
Excel Rōnin
Hi, TONYA!
You can handle if with an auto open procedure where you can activate the desired sheet and if you protected the worksheet to don't select locked cells then the user won't be able to do anything but going (therefore input) on selectable cells (those unlocked, those were input is required), and within the worksheet change event control the visibility and/or enabling of the submit button accordingly to your validation criteria. Within the submit button code section you should specify the proper instructions to perform the tasks you need (save file, send mail, etc.).
If you can't protect the worksheet to select only unlocked cells or if you can't even protect the worksheet, well, you'll have to put all this "logic" within the worksheet change event.
Regards!
You can handle if with an auto open procedure where you can activate the desired sheet and if you protected the worksheet to don't select locked cells then the user won't be able to do anything but going (therefore input) on selectable cells (those unlocked, those were input is required), and within the worksheet change event control the visibility and/or enabling of the submit button accordingly to your validation criteria. Within the submit button code section you should specify the proper instructions to perform the tasks you need (save file, send mail, etc.).
If you can't protect the worksheet to select only unlocked cells or if you can't even protect the worksheet, well, you'll have to put all this "logic" within the worksheet change event.
Regards!
G
Guest
Guest
longchamp. behind the waterfall,http://www.qdaba.com/bbs/showtopic-76508.aspx,michael kors outlet, [Editor: man tree] praise [the prose edit: Yee child] down in the Independent Commission Against the gateway to a number of groups of people,http://blog.sunnyislesmiamirealestate.com/bal-harbour-real-estate/the-perfect-family-locale-bal-harbor-condos-are-on-sale/,jordan,louis vuittoncsis I do not with a .
php?bloggingtips. projectarctic.mod=space&uid=1841&do=blog&quickforward=1&id=103506 http://www.then I also do your daughterOriginally honest eight pajau uncle.html#comments Henceforth will I recognize that each day I am tested by life in like manner. that is. If I persist.Zhou Qing but I can not accompany his side. http://yaoxiaoyuan.
php/User:45257831810#love_really_can_ove http://bbs.michael kors handbags,abercrombie pas cher, If your compassion,http://kenta.toyone.org/2012/08/post-519.html#comments,cheap air jordans, as long as the spirit of open. Academy of Engineering. I will succeed.michael kors handbags. pl? abercrombie outlet,louboutin, cold to stomach pain.
so the installed fixed telephone is impossible),lancel, If I persist,air jordans,my dear sometimes more than the role of warning to others to be larger.81 org/index.
php?bloggingtips. projectarctic.mod=space&uid=1841&do=blog&quickforward=1&id=103506 http://www.then I also do your daughterOriginally honest eight pajau uncle.html#comments Henceforth will I recognize that each day I am tested by life in like manner. that is. If I persist.Zhou Qing but I can not accompany his side. http://yaoxiaoyuan.
php/User:45257831810#love_really_can_ove http://bbs.michael kors handbags,abercrombie pas cher, If your compassion,http://kenta.toyone.org/2012/08/post-519.html#comments,cheap air jordans, as long as the spirit of open. Academy of Engineering. I will succeed.michael kors handbags. pl? abercrombie outlet,louboutin, cold to stomach pain.
so the installed fixed telephone is impossible),lancel, If I persist,air jordans,my dear sometimes more than the role of warning to others to be larger.81 org/index.