How To Insert A Submit Form Button In Excel - Submit Form to Email - Create Fillable Forms in Excel

[@daicaghund3587]

I used this recently but had already made a shape. Figured out I could still use a shape in place of the grey square command one so quite happy. Thank you.

[@SharonSmith]

Awesome! Glad to be able to help! Thanks for watching!

[@maryrobinson5601]

Great step by step instruction! Thank you!

[@SharonSmith]

Glad you found it helpful! Thanks for watching!

[@seanmaxwell294]

Hi Sharron. Is there a way to only send the current sheet opposed to the entire workbook? Thankyou

[@finoj1385]

Wow! I'm looking like an expert with your help! This was a fantastic video!

[@SharonSmith]

That's awesome, Joseph! Glad you found it helpful. Thanks for watching!

[@jaycal1920]

27 seconds in, Thanks Sharon this is the first video I am watching, my goal is to have a submit button on sheet 1 that will post field results into new lines on sheet 2. For example an invoice that is filled out on sheet one then it is posted as a new line as an invoice record on sheet 2....Also sends to the printer. Will keep watching but not my intended result.

[@katarina.reynolds]

Thank you! have tried many codes to try and get what i want and this is exactly it!!

[@SharonSmith]

So glad you found it helpful, Katarina! Thanks for watching!

[@cherubicchild5]

@sharonsmith Loved the video. While attempting to implement I am.getting the following error: Compile Error: Invalid Use of Object.

[@francesdobbins2964]

I really enjoyed your video. It's helping me to improve my Excel skills.

[@SharonSmith]

Thanks, Frances! That is great to hear. I'm glad your Excel skills are improving! Thanks so much for watching my videos!

[@manojraturi1977]

Thanks Sharon mam!! Once again great tutorial for me. Please keep it up your efforts for learner community.

[@SharonSmith]

Thank you so much for watching my videos Manoj, and thank you for your encouraging words. I really appreciate it!

[@nthabisengsmarts7013]

Worked like a charm, thank you Sharon! 🤗

[@SharonSmith]

You are very welcome! Thanks for watching!

[@varunrai1671]

Nice video ,easy to understand really helped me to automate mails from excel

[@SharonSmith]

Great to hear! I'm glad you found my videos helpful. Thanks so much for watching!

[@iscariotpaladin5363]

Great video fairly easy to follow. I was wondering if you have video on how to make a form in excel with a submit button that when press send the data to another excel sheet that adds and logs the data when submit is press.

[@jlongo123]

Excellent job!

[@SharonSmith]

Thanks so much! Glad you found it helpful!

[@kimberlykelly7845]

Perfect instructions! Thanks

[@SharonSmith]

Glad to help! Thanks for watching, Kimberly!

[@Raymondthach1314]

Hi Sharon, thank you for sharing this helpful lesson. However, I run into an issue that the send button only attaches the original file to the email. it won't attach the file that I fill in with information without saving the file. Would you help me to fix it?

[@Pontsticilljohnny]

WOW thank you so much made it look simple even when i did have the first clue. would i be possible for the email text fields to be an input form individual cells in the spreadsheet?

[@xanthesoter6457]

Super helpful videos but one quick question that might be confusing. Is there a way to take the fillable form data auto-populate a larger excel spreadsheet. For example, I'd want to send out this form to a handful of people and want to have the responses organized into one large excel spreadsheet. So is there a way to have the forms auto-populate a larger data table without having to individually copy all of the information into my larger dataset? If this isn't feasible with this method is there a different way you suggest in making an excel spreadsheet that looks nice and is easily fillable by multiple people without them messing around with the sheet by creating new columns or changing the size of columns?

[@jesseorozco951]

Is there a way to do this but have the table or in your case the form populate in the body of the email instead of a file attachment?

[@therealreyfamily]

What if I want the email to and CC to be auto filled by a reference in the workbook? Can this be done?

[@rahemnahida9871]

Super helpful video, thanks :)

[@SharonSmith]

Glad to help! Thanks for watching!

[@cyrilthomaspandian3333]

Great video. Thanks for sharing.

[@SharonSmith]

You are very welcome! Thank you for watching!

[@alivecreation1097]

Helped a lot... Thnk u so much 😊

[@susankilpatrick428]

Where did you get the VBA code to copy into the sheet 1 ??

[@dannybejjani]

Hello, thank you for this wonderfull tutorial, but what if I want to send every time the last record in a table? What is the code that I need to adopt? Thank you

[@SmileysSCHouse]

submit button form to prepopulate excel file data 7:15 Thank you for these videos. I'm trying to work out how I can collect the data from the submitted forms with the submit button into a spreadsheet. I have managed to do one line, but I cannot work out how to get the next line, it just writes over itself. I then want the next line and so on to prepopulate when lots of people will be using the form . I want the data to go to the next line after each submit button is selected. Does that make sense ? So when I select the Submit button, it overwrites the previous submission populated row in excel table instead of going to the next line automatically. Many thanks for your help - have been following for a while. You explain things beautifully.

[@genevievedecker7153]

is there a way to do this for office365 (not the app?) Thank you!

[@TechAdmin]

Hi Sharon Thanks for the information. but i want to send a sheet not complete excel file can you pls guide for that

[@petesmit33]

very good thank you but one question - will this only open Outlook as the mail client? what happens if the customer doesn't use Outlook as their mail client?

[@albyi1984]

Thanks for this video. Great help. One thing I noticed was the attachment seems to be named differently due to special characters. How can you delete that?

[@joshuagrimploma9171]

Question? do you have video that the user doesn't need to click the attachment to see what's inside the excel file?

[@mabr3595]

Hi Sharon. Thanks for making this super easy. I'm having an issue with the submit button; it won't allow me to click the button to submit the pdf form. The form is protected, there are locked fields and the fillable fields work. Can you assist?

[@chrisstaniland5271]

This is great! Thank-you. If I want to be the one who fills the form and sends it to the same recipient daily, (like an order form) can the “submit” button be made to disappear when the recipient opens it? Hopefully the question makes sense.

[@SharonSmith]

Hello! If you are familiar and comfortable with VBA, there is a way you can set this up. You will have to save the file as macro-enabled. Here is some additional information: Yes, it is possible to design the form in Excel such that the "Submit" button disappears after the recipient opens it. This functionality can be achieved through VBA (Visual Basic for Applications) code. Here's a basic outline of how you could implement this: Create a Macro to Hide the Submit Button: You can create a VBA macro that hides the "Submit" button when the recipient opens the Excel file. Trigger the Macro on Workbook Open: You'll need to set up an event handler in VBA that triggers the macro to hide the button when the workbook is opened. Lock the Macro: To prevent the recipient from viewing or editing the VBA code, you can lock the VBA project with a password. Here's a simplified example of how you might write the VBA code: Private Sub Workbook_Open() ' This macro hides the submit button when the workbook is opened Dim btn As Shape On Error Resume Next ' If the button is not found, ignore the error Set btn = Me.Shapes("SubmitButton") ' Change "SubmitButton" to the name of your submit button On Error GoTo 0 ' Reset error handling If Not btn Is Nothing Then btn.Visible = False ' Hide the button End If End Sub To implement this: - Press Alt + F11 to open the Visual Basic for Applications (VBA) editor. - In the VBA editor, find your Excel file ("VBAProject (YourFileName.xlsm)") in the Project Explorer. - Double-click "ThisWorkbook" to open the code window. - Paste the code provided above into the code window. - Replace "SubmitButton" with the name of your actual submit button. Remember to save your Excel file as a macro-enabled workbook (*.xlsm) to retain the VBA code. Once implemented, when the recipient opens the Excel file, the "Submit" button should automatically disappear, making it a one-time use form for submission. Ensure that the recipient does not have access to the VBA code, or consider locking the VBA project with a password to prevent unauthorized access. Test thoroughly! Hope this helps! Thanks for watching my videos!

[@DTonkins420]

Thanks this is great. Any way to put some of the data from the sheet into the body of the email you send? for example put whatever is in cell B2 into the second line of the body of the email.

[@jfam1964]

Thank you for sharing! Question why I don’t see how make work in Microsoft 365 please help thanks

[@niccipez]

thank you for sharing this. Once I receive the completed form, how do I automate to populate the data into a spreadsheet in teams?

[@shoipintbrief]

Fabulous, thanks Sharon!

[@lupuelenadiana2067]

How do I send only a sheet from the workbook and not the whole workbook?

[@Darioq57]

Thank you for the video, you rock!.. My issue with this video is that when Outlook opens, verything is great but! Email is never sent out. My only guess is that there is not sender on that outlook window that comes up. Please correct me if I am wrong. Email is never sent. If you have time, I will appreciate if can help be fix that. When I click on send, everything looks great and looks like the email was sent but email never received.

[@willielee4623]

GREAT Video!! However, i noticed that the layout of the developer option in excel for macOS is kinda different from what u have. Do i need to get a different version of microsoft or i cannot perform the same procedure with a macbook?

[@SharonSmith]

Hi Willie! The MS Office applications on Mac have a different user interface (even if it is the latest version). You may be able to do similar things, but may have to search for how to do the same things in MacOS. Sometimes on the Microsoft documentation site, they provide instructions on how to do things in PC and Mac versions, so hopefully that will help you out. Thanks so much for watching my videos!

[@eagleslandin1692]

Sharon, great video. Can you tell me how the code is able to attach the file without saving? How is the updated form attached without saving it first?

[@therob12321]

Sharon! Brilliant video! One problem I am having is my form is not including the information entered into the form, it just sends a blank form... any idea how to fix this? would be a huge help!

[@nancyk8124]

I had the same problem. I found that you have to have the user save the file first locally, and then they can click submit. This will save what they entered and email the document with the saved info. I wish though, we could force the save through the VBA code, as I am sure users will forget to click save before submitting. Sharon, any thoughts on this? - thanks for this great video!

[@katiekat9669]

@@nancyk8124 did you ever find a solution to this, I have been trying to fix this for weeks.

[@UsmanKGB]

Hello Katrina, super helpful video, I wonder if you can help me a bit further, i am trying to add a button to email and attach a spreadsheet tab (not the entire workbook) and remove any formulas from the sheet and leave the content as data before i send the spreadsheet tab only and give the attachment a label, as well as insert emails addresses from cells within the workbook but in other tabs, let me know if you have. Thanks. (:

[@mihajlovicrus]

Great, that is awesome !

[@franklabeaf2159]

Sharon. Great tutorial. How do you send only the active worksheet (form) and not the entire workbook?

[@SharonSmith]

Hi Frank, thanks for watching my videos! With this particular VBA code, it will attach the entire document. Would you be able to save your form worksheet as a separate file that you could attach? If you have sheets in your workbook that need to remain, are you able to make them very hidden? (Here is a video on how to make sheets very hidden: kzbin.info/www/bejne/npKXfat5hayXhsU). Hopefully one of these options works for you. Take care!

[@priyankasalian8174]

Where did you click for the vba code

[@SharonSmith]

Hello! It is in the expanded description of the video. Thanks for watching! Here is the VBA code used in this video to create the macro for the Submit command button (be sure to replace the Subject, Body Text and Email address with your own information): Private Sub CommandButton1_Click() Dim xOutlookObj As Object Dim xOutApp As Object Dim xOutMail As Object Dim xMailBody As String On Error Resume Next Set xOutApp = CreateObject("Outlook.Application") Set xOutMail = xOutApp.CreateItem(0) xMailBody = "Type the body or your email message here" & vbNewLine & vbNewLine & _ "Use this if you want a separate line of text" & vbNewLine & _ "Use this if you want another separate line of text" On Error Resume Next With xOutMail .To = "[e-mail]" .CC = "" .BCC = "" .Subject = "Enter the Email Subject Here" .Body = xMailBody .Attachments.Add ActiveWorkbook.FullName .Display 'or use .Send End With On Error GoTo 0 Set xOutMail = Nothing Set xOutApp = Nothing End Sub

[@MrLaszlo82]

Hello, how we amend VBA code, so attachment in the email is in pdf format please. Other then that its work perfectly Thank you

[@leciamiller5746]

How do you copy the via for the submit button

[@tiareamezcua2756]

If the file is a read only - do you have to save it before sending it as an attachment after it is filled?

[@kathyadams5917]

I have a little issue with this, Many of our users don't use Outlook. How can I set this command button up to bring up the users default email client instead of just defaulting to outlook?

[@delsoramos2881]

This what im looking for but i need it to send a specific area of the worksheet as a pdf instead of the whole worksheet as an excel.. idk if thats possible

[@MusicIsLife2308]

I need the exact same thing too!! Been looking everywhere for an answer. I would like it so that it exports the defined page of the excel as a .pdf and attach that to the email

[@carlainovero5924]

How to add submmit button not for the email but for the another sheet.

[@joannesmith7733]

Hi Sharon, I accidentally asked this question in the comments of another video. I appreciate your videos. My question is (I see this was asked a year ago, but do not see a response.) ... Is there a way have the submissions populate into an Excel spreadsheet once the user hits submit? How would you recommend we do this? It just doesn't do me a lot of good to collect the data without this option. Also, for users who do not have Excel, if I convert this into a PDF file, will my options (down arrow items) still work, and how do I get all of that info into an excel spreadsheet. Your reply is greatly appreciated. Joanne

[@Hello-sr8qi]

How do I remove the %20 from my attachment for space??

[@shelialebeauf2461]

Hi Sharon, great video, easy to follow, and use. I would like to take the button to a higher level. How do I add a hyperlink to the file so that multiple Approvers can review/approve the one file? Also, having multiple Approvers, how do I add code to pull the Approvers email from the signature setup into the To: line of the macro instead of hard coding in the macro? Only one approver can approve at a time, one after the other.

[@juncardenas5709]

How can you create two submit buttons on the same excel workbook?

[@juncardenas5709]

Figured it out :)

[@SharonSmith]

Awesome! Glad you figured it out. Thanks for watching my videos!

[@SharonSmith]

Glad you figured it out! Take care!

[@boffiee]

Thank you! Built a nice excel template for customer request towards our customer service using this template. Splendid :)

[@SharonSmith]

That is great! So glad you found it helpful. Thanks for watching!

[@heatherdavis6152]

This is great however I seem to be having trouble with the form keeping the information once form is submitted. When customer hits submit, we receive the email as set up but when we open the form, none of the customers input shows up. What am I missing?

[@Raymondthach1314]

it happens with me as well. I'm not sure what did I miss?

[@peteronderwater4269]

Hello Sharon, thanks for the video. I have a question: Is it possibible to change the font in the video?

[@peteronderwater4269]

I mean in the mail. 😊

[@SharonSmith]

Hi Peter! Thanks for watching! One option would be to save an email "template" with the font and formatting you want and then modify your VBA code to create the email from that template. If I come across another way, I'll do a video. Good luck!

[@peteronderwater4269]

@@SharonSmith Hi Sharon, Okay, thank you. I'm going to work on it.

[@syedikramullah1114]

Sharon please, make a video on a word replace all options. how to use these all options in Microsoft word.

[@clifordakoyo406]

can it also work for gmail or is it outlook only?

[@parthasanyal9259]

Can I send the pdf file instead of macro sheet by email with the single button click??

[@AIRNSWORDZ]

How could I add a code that when they submit it will not only create the email but it will reset the form by removing the entries?

[@cochinito1]

Thanks! This is exactly what I've lloking for. If I want to have a table with every response, how can do that?

[@goosphil]

How to modify the code to use another service than Outlook?

[@claudesavard8171]

Works well on my desktop but when I try and open it on my phone I get an error. From what I can find on the internet, VBA code will not run on android phones. Is this correct. Is there a workaround to this issue.

[@michellesanjuan4737]

How to change the file name when press submit ?

[@travislintern9677]

Sharon, Great tutorial! One question, is there a way to hide the submit button so when I open the attachment in e-mail the submit button is not there?

[@captainnemospubgrub6994]

Hi Sharon, I think this is what I might be looking for but I am wondering if there might be someway to send it to another excel file using a home group or to share it with me. Also, is there a way to have the fillable cells go back to zero after the worksheet is summited or emailed. At my business my employee's count their cash drawers. I just finished a tailored spread sheet that calculates all the totals for them. After they summit it, I need a fresh copy for the next shift? Hope you can help, You seem to know what you are talking about. Thanks, Patricia

[@chidanandar6606]

Popup menu saying there is no email program associated to perform the request. How to get solve this

[@samitbeileh520]

Hello, When I click on "Send" in the Outlook, I didn't receive anything. I also tried to enter a gmail email, also, it didn't work. Please advise. Thanks,

[@zeusm8859]

hi, i want to put a form (in excel) on my website. customers will open the form, fill it in and press the submit button on which they will be asked to login to their email (outlook, express, gmail, hotmail, yahoo mail etc etc....) after which a blank email with my email address, a standard line in the subject box and the order form attached as an email will open which will be sent by the customers. it will be received in my mail box. hope my question is clear....is this possible, just like the 'share this' button on many websites where it allows customers to choose how they want to share the site...gmail, hotmail, facebook etc.....

[@ryukoros]

Very cool! But I am wondering if I can use the same code to help populate my excel spreadsheet with a date and timestamp as acknowledgement that they read my email to multiple people? Cause I know people prefer to just push a button than to type that they read it (and I am one of them). lol

[@aset012585]

Hello! Is there a way to add option button in the body of the email? Example is to add Approve / Reject option That receiver can use in replying to the same email?

[@SharonSmith]

Hello! There may be a way to write the VBA code to activate the voting buttons in Outlook. If I find this, I will do a video on it. The sender has the option to manually add the voting buttons before they send the email. I hope this helps! Thanks for watching my videos!

[@asembi19]

Where can I find the VBA code to download?

[@SharonSmith]

Hello - you can expand the description below the video to see the VBA code. Here it is for you: Here is the VBA code used in this video to create the macro for the Submit command button (be sure to replace the Subject, Body Text and Email address with your own information): Private Sub CommandButton1_Click() Dim xOutlookObj As Object Dim xOutApp As Object Dim xOutMail As Object Dim xMailBody As String On Error Resume Next Set xOutApp = CreateObject("Outlook.Application") Set xOutMail = xOutApp.CreateItem(0) xMailBody = "Type the body or your email message here" & vbNewLine & vbNewLine & _ "Use this if you want a separate line of text" & vbNewLine & _ "Use this if you want another separate line of text" On Error Resume Next With xOutMail .To = "[e-mail]" .CC = "" .BCC = "" .Subject = "Enter the Email Subject Here" .Body = xMailBody .Attachments.Add ActiveWorkbook.FullName .Display 'or use .Send End With On Error GoTo 0 Set xOutMail = Nothing Set xOutApp = Nothing End Sub

[@dennisanddogpound734]

Where did you grab the code ?

[@___DannyBoyka]

Can someone help what to do incase user doesn't have outlook ?? Please help!!

[@justinkayla2006]

Is there a way to attach the completed form to the email instead of the blank attachment? I trying to create a public form for employees to fill out and once it is filled out they can hit submit and send it to the assigned recipients. BTW, Thank you for these videos!!!!! They are lifesavers!

[@egcarter4308]

This video is great! Followed step-by-step and added submit button. When the form is sent to the email address associated in the Developer tool portion, the form is received blank and all typed in information has disappeared. Is there a solution to this?

[@SharonSmith]

Hello! Please have users save the document prior to hitting submit. This should allow the filled in data to be retained and sent in the attachment. Hope this helps! Thanks for watching!!

[@nancyk8124]

@@SharonSmith Hey Sharon, any way we can have VBA code do it for the user? Can the code check for it before opening up outlook? I am sure users will forget to save the document before hitting submit. thanks for your super clear explanations!

[@MsBomba1972]

What if clients have different email program

[@amypuffer3871]

Sharon - Great Video!! Most of our clients do not have Microsoft Outllook - Can I change the code? If so, how do I do that. Thanks

[@goosphil]

I have the same problem. Do you have any solution, Sharon, please?

[@erangaaw2542]

Hi how to make the excel form pdf

[@brax5402]

Can this be programmed to use any email system, gmail, exchange, .net, etc?

[@jeffstahl1899]

Has this question been answered?

[@sharonchen853]

The file is blank when I receive the email. Did I miss anything? Can someone help me? Thanks

[@zeusm8859]

When clicking to view code- there is no vba code on my sheet. Where can I find the vba code or must I write a vba code? Very new to a vba code.

[@SharonSmith]

Here is the VBA code in the description of this video. Hope this helps! Here is the VBA code used in this video to create the macro for the Submit command button (be sure to replace the Subject, Body Text and Email address with your own information): Private Sub CommandButton1_Click() Dim xOutlookObj As Object Dim xOutApp As Object Dim xOutMail As Object Dim xMailBody As String On Error Resume Next Set xOutApp = CreateObject("Outlook.Application") Set xOutMail = xOutApp.CreateItem(0) xMailBody = "Type the body or your email message here" & vbNewLine & vbNewLine & _ "Use this if you want a separate line of text" & vbNewLine & _ "Use this if you want another separate line of text" On Error Resume Next With xOutMail .To = "[e-mail]" .CC = "" .BCC = "" .Subject = "Enter the Email Subject Here" .Body = xMailBody .Attachments.Add ActiveWorkbook.FullName .Display 'or use .Send End With On Error GoTo 0 Set xOutMail = Nothing Set xOutApp = Nothing End Sub

[@eannacookie8491]

Really enjoyed your video. Followed step-by-step and added submit button. When the form is sent to the email address associated in the Developer tool portion, the form is received blank and all typed in information has disappeared. Is there a solution to this? Is anyone else having this problem?

[@caitlindavis9628]

Any luck on an answer??

[@eannacookie8491]

@@caitlindavis9628 No response from Sharon Smith

[@peishantan4903]

Same

[@southernstunna]

is there any way you can give us the code to send just a single sheet (vs entire workbook)? It should be very simple. Thank you!! video was great and looking forward to watching more of the channel.

[@garrettkim-antoni]

Hi Sharon. I’m having one small problem: Whenever I receive a submitted spreadsheet back it is completely blank. All of the filled in information is removed. This only happens when they submit the spreadsheet back using the submit button. Is there a way to fix this?

[@SharonSmith]

Hi Garrett. Please have your users save the filled in form prior to hitting submit. Thanks so much for watching my videos!

[@nurohp2]

@@SharonSmith is it possible to make it save and attach the document. 90% of the people forget to save before sending. thanks for the video.

[@syedikramullah1114]

Nice

[@SharonSmith]

Thanks for watching!!

[@darintexas2]

Thank you for the video! Question: What if clients do NOT have outlook as their email provider...most of ours do not....how can I amend the code to be used from any email?

[@goosphil]

Yes, it looks that many people have this problem but we are still waiting for Sharon tips.

[@___DannyBoyka]

Same problem!...did u guys have a solution yet ? My work is due next week..help pls!

[@marshmeio5842]

tnk

[@SharonSmith]

Thanks for watching!

[@farestahamohamed835]

Very Nice But I send you one Message Error thank you again from Land of Pharaohs

[@aaronberry6577]

Where did you get the vba code to paste in the command?

[@mahdiananto2392]

How do I email any particular sheet instead of full file?