Wow! This video left me speechless! THANK YOU SO MUCH! Now I can finally make a fill able form that will submit and solve a lot of problems in my school district.

Excellent job. Short, to the point and extremely helpful. Thanks!

Amazingly well taught!! Extremely clear and helpful. Thank you!

Great post. Thanks for this, it was exactly what I've been looking for.

Thank you so much for this tutorial! It was extremely helpful.

The link is broken.. do you have another one?

Great video exactly what I was looking for. Thanks!

Very helpful! Many thanks for sharing this.

Neil, you're the man!!! thanks

Thanks so Much. I also want to the document to save in a network drive, how would i go about that code for the submit button

Hi Neil Thank you for the code but how do I get my form to reset form fields once I press the submit button and also not to save just send the email. Thank you I am learning so much.

Thank you so much! Excellent Video.. worked like a charm.

Great video and thank you. Is there a way to save the contents of the form to an Excel spreadsheet or create an email "Submit" command button with an Excel VBA userform? Thank you.

Thanks. It works like a charm! Much appreciated.

So I was able to get everything to work as you had listed in the how to. However I wanted to find out if there was a way for the form to be submitted with the information typed in it but to not save over the original blank form as I will have multiple people using the form from a shared computer.

Works great! Thank you. But now i'm looking for a macro that would open an Outlook (Word) attachment, fill in some info then send back the attachment with my info filled in (without first saving the attachment on desktop, etc.). Would appreciate any tips on this. Thanks.

You made my day! Thanks!

Thanks a lot !!!! Great tutorial

Yay! This is awesome. Thanks!

Very helpful Neil - thank you! As an alternative option, is there a way to just pull the data from the content controls and have it populate the body of the message, rather than attach the whole document? I'm thinking of an inspection form where it's nice to have a formatted document for the person completing it, but the recipient really only needs to see the content entered.

Hi Neil thank you for this video it really helped. I do have a question in regards to the email client. I am creating a form for work and we do not use Outlook instead use Lotus Notus. Is there a way to set the code to the default mail client for the system?

Hi! Thanks for the great tutorial. I have one question... with Word, macros seem to be attached to the program on a specific computer, and not to the document itself, like with Excel. How do I share the Word form that I have created with others in my department, that has the macro attached to it and ready to use?

how to create macros which can show popup text field and I can fill it with necessary data. I need it because I have big text in which I need to edit a few words in different places.

Where did you get the macro code for insertion? I need the long version so the forms can be sent to one email address without further input from the submitter.

Is there a way to generate the email in a user's default email program (ie Live Mail, Outlook, etc.)?

I would like to be able to also have the file saved to a specific folder on a shared network when the submit button is clicked. How would I do that?

Thanks for the Video Neil. Is there any possible code that brings up your Outlook signature once clicking the button and displaying the draft email before submitting. I have one from Excel but it doesn't work for word.

So maybe I've overlooked it, but say I want to send the form to multiple user and dont know the email service they are using, or perhaps they will submit via a mobile device. is there a line code I can replace on the long version that will submit email using the receivers default email?

How do I create a button or drop down list where I can check a box to select who the document will be sent to, then click on a submit button. I want to be able to choose different email address each time.

love this video but need help. had it working but has stopped working now. should i go out of develope mode and save. when i open the form and click submit i get a fail at doc.save

Brilliant. Been searching forever for instructions as clear as this. Is there a way to change the importance from Low to High? I see olImportanceNormal in the script but mine is coming up low priority and amending it to High in the script has no effect. Small issue but would be handy to know how to change.

Can a person without Outlook submit this form? If not, is there a way to allow all mail clients to be able to submit the form? Thank you!

hello thanks for the video i a novice i tried it and it worked but i want to put the form on my site assuming the senders dont have outlook configured on there system how else can they submit the form please help with the code

Hi, is there a way that the link to download text file could be fixed. I would love to use the macros

Yes it worked!!! THANK YOU!

Neil can you show me where I can get the marco to send the email or the long macro? Thank you

Hi Neil. This worked great when I used and tested it on my laptop. I e-mailed the document to a coworker to test and they were getting flagged with debug errors and it was trying to force them to save the document. We never could get it to send. We are using MS Word 2013. Any suggestions?

Hi Neil,Thanks for posting - this video has helped me (3 years after you posted, lol). I was just wondering - the form I am creating needs to open Outlook with the attachment included along with a default To: and CC:. How would I update the macro so that this populates? The end users are supposed to adjust the Subject: and body of the email. Hoping you could assist me with this - if not, hopefully you can lead me in the right direction.Thank you!!!! :-)

Hi Neil. Great job! I am a novice. The code works for me but when I tried to add the CC line so that I can copy another email address, I had trouble with this line: submittedEmail = .FormFields("YOUR FIELD NAME").result What do I put in the "YOUR FIELD NAME" Thanks!

Can this set up use for word mobile on IOS or Android ? Thanks

Hello, I got this done and it works fantastic in my computer, if I want anybody else to use it, I share the document but when they are trying to submit they get an error related to Set EmailItem = OL.CreateItem(olMailItem).. any idea how to fix it?

Hello! My boss has given me a seemingly impossible project and I need some direction. I've included the submit button but I need to adjust for the following variables... - They cannot submit until certain fields are completed, - It will populate into an e-mail and the client name would pull from the form (Subject Example - "New Client Set-Up for [INSERT CLIENT NAME FROM CLIENT NAME FIELD IN DOCUMENT], - Instead of e-mailing can it be routed to save into a folder instead?? Any suggestions would be very helpful! Thanks, y'all!

Neil this is unreal for novice macro user. The short macro works great but keeping getting error messages with the longer version that doesn't require any email input. I copied the macro directly from the site. If I can get this to work my questions going forward would be: 1. can the macro be set so that a generic email program can be used rather than it being specific to Outlook. This way the responder can use the email program that resides on their device. 2. Is there a way to show that the doc has actually been sent 3. option to save their doc on send.

Hi Neil & all, great video & it worked the first time I used it. But when I went back into the document it had cleared out all of the code and now it is highlighting the last word in this bit of code: Application.ScreenUpdating = False and giving me the message Compile Error: Invalid outside procedure. Any help would be appreciated.

Neil, I have used this process in the past and it work just fine. Now when I use it the receiptent is asked to "save the document" which I don't want them to do. The document is a "template fill-in the blanks form". We are having this issue a lot any suggestions? Thanks...Annette

Hey Neil. I was so excited to find this explanation. I built the script just as described. It worked fine the first time, but now I get a Runtime Error . . . it seems to have an issue with the line ".Attachments.Add Doc.FullName" - That's the line highlighted when I debug. I'm using Word 2016 and the file is saved on my Work One Drive for Business (I'm operating with local programs, not on web). Any ideas???

I am not able to get the MACROS from the published link. Can you post or send to me please?

Hello! Could you use this to send to send bulk email messages from Word? For example if I'm inviting people to an event, could I use this button to have them signed up if they want with little to no effort?

How can I code in the smtp information user name and password so that it always comes from a specific email address when you press the submit button, also to send to multiple peaople

I followed the second macro code you used but it did not give me the dialog box asking to send the email? what might of gone wrong?

"Thank You", thank you very much 😋 Is there a tutorial on how to submit the information in the form, to an MS-Access database 😐😋😐 Let me know. I look forward to hearing from you 😎

Hi Neil thanks for such a helpful video. Neil is there anyway where we can attach .pdf, .doc, docx, .ppt.xls file in developer tab - control option. I got the one for pictures but the same is supporting only for .jpeg and .png format.

Hey Neil, thanks for the great video. I am looking desperately for a solution and I am already wondering that nobody has asked this already. I want to create a Form in which you can fill out a page and if necessary you can dublicate this exaxt page by clicking on a command button. I am nearly succeeding in creating the right macros, but my problem is that this button won't stay on his place, because above of it I placed a "content control element" which contains for certain choices two written lines and pushes the button down, so he needs to be embedded and stay where he belongs, for gods sake!!! So I really do appreciate an answer from you. Best regards

I do not use Outlook for my email, I use a gmail account, what do I type in for the submit button properties?

where did you get the macro from? is it ok to copy yours into mine

I know this video is relatively old but this submit is great. My question is I have entered it in and everything works but I do not want the original document saved. I use it as a security report that multiple people use so i need it to send with the data entered but not modify the original document. I have removed the Doc.Save but now it will not submit with the data entered. Any help would be appreciated.

Is there a way to combine the two submit types: I want to send the form, attached to an email, while inputting the to: field and the Subject: field but I want to allow the sender to add a cc: and anything they want to the body. I just can't figure out what the combination of the code should be or if it possible.

Hi. Great video.I would like to ask for something: (Re "No-option" code) 1. I'd like to ask if it's possible to add command to prompt user to "Save As" document every time they want to click on "Send" button. Now once it saved it will email document with the same name even if I make some changes (changes will be saved in attached document but with the same doc name). 2. Many people said if it possible to add some message that email has been sent etc. I've managed to change command .send to .display and as least outlook stops there and then I need to click "Send" button, which gives me change to see email before will be sent. Thank you

Created the buttons ok. Changed its name ok. double clicked and brought up the next box ok. How do I get the Macros to enable me to use the submit button to email the document? Any help would be appreciated...

Hi Neil, great tutorial! How do you get the macro codes for the larger macro?

Hello, Is there a way to have a verification e-mail sent to the person submitting the form?

How do I create a button in a Word doc that opens Outlook, attaches the document, and puts a specific email in the "To" box. I want to allow the user to add their own body text rather than automatically sending the email.

The problem I am having that the data from the form is not coming over once the end user submits the form. What seams to be the problem

What code should I add so that the email address I want to send it to should be pasted already when clicking on the button? I don't want the template to be sent directly. I want it to open in outlook but with the email address attached? Please help!

can you provide me the code to have the bigger macro and the smaller macro combined so that it can do this - have outlook displayed with the attachment and the To button on outlook showing the various email recipients addresses.

Hei, nice one here thanks for this video. can i request to make a submit button where the information in word is save to another word file?

Would you be able update the link to the two macros? The link's not working

Hi Neil, this video is great. Thank you. I have created a "feedback form" in Word 2010 and am required to save it as a .dotx file (I am studying and this is part of the instructions I need to follow for a project assessment) The "no-option mail sending code" you provided works great. My problem is that part of my project is to also create a web page in word and then I need to link the feedback form to the home page for completion and submission by visitors to the page. Upon testing this link, I noticed the form opens in a brand new document and when the '"Submit" button is clicked it does not automatically save the new document and email it, but instead only opens the "Save As" option. Can u perhaps help me with a code that would automatically save and email any new documents opened from this .dotx template?

How do I add multiple .Cc recipients? I have one "to" addressee and one "Cc" which works fine, but when i tried to 2 additional "Cc" recipients, I can't get it to work no matter where or how I add them in. I've tried all on one line not separated, separated by semi-colon, colon, comma, space, and I've tried 3 separate .Cc lines, but that resulted in only the 3rd recipient actually receiving the email; the first 2 .Cc recipients didn't receive anything. Someone help me please - I'm driving myself crazy trying to figure this out!

Hi Neil I am using word 2013 fallible forms under developer tab. I have created two columns 1. When you hit the tab key how can you make it so it stays in one side of the column only and just works its way down the page until you click enter to the next column 2. How can you restrict the amount of Charters in the control box under developer mode to say 15 letters only? 2. How can you make the control box only accept number when required? 3. How can you embed $ and % signs in your control box. Any help would be greatly appreciated I am creating a complex 6 page fallible form. 4. For this video about the submit button are you able to give me a step by step where you actually got the macro from to do the submit in the first place please

Hi Neil, This code has worked perfectly for me on more than one occasion, but I'm creating a new form and I want it to be sent with "High" importance, but for some reason it still keeps sending at "Low". This is the line that I've changed: .Importance = oIImportanceHigh (from the standard Normal) Any ideas on how this can be fixed? I'm using Word 2010 on a Windows 7 machine.

Neil, Can you provide the link to the video you did to create the macro you reference in this video? I am trying to create a macro to combine multiple excel docs into one master doc and thinking that the video you've referenced may help. Or if you have any other tutorials that would be useful please advise. Thank you,

Hi, I do have a question. I have created a Microsoft Word fillable form with dropdown fields, text field, etc but I would like to convert this form to Google Docs. After conversion I want to upload the form to my website without breaking the Integrity of the form. So whenever a customer fills out the form and send it, it generates a PDF version of the form where it would be sent to my email. Is there a way to do this ?

Hi Neil, I've been going crazy over finding a way to save the file according to certain criteria that was answered within the form. For example, taking the form in this video, I want the "save & submit" button to save the document using the name and date fields, like so: "Current Policy Initiatives - Neil - OCT_10_2013.doc." To make things a bit more complicated, however, each field in the form is a "controls" feature from the developer tab, one of them being the "date picker content control," and the other "Rich Text Content Control." Is there any way to make this happen? I've searched everywhere and cannot find a solution, so if you can help with this that would be awesome! Thank you!

This works great but I don't get the Outlook dialogue box asking me to allow it. I'd like to see this...because clicking it makes me feel like it is sent. Right now I hit the button and it is sent. Happens so fast I'm not sure it went. Is there a way to have a box open letting the sender know it was sent

Great tutorial! And so easy to follow. Is there a way to bypass outlook and allow users to use a web based email provider? Specially if they are completing the form at a shared computer and hence do not have access to outlook.

I'm getting a Compile error: Variable not defined. at the Set EmailItem =OK.CreateItem(olMailItem)

Is there a way to add in a prompt? Plus if they don't save the file first it gives the user an error. Is this something that I did wrong in my code? Thank you! Also, great job on the video! It was incredibly useful!

What if i want to send to or through gmail or organisation email without Outlook client?

Hello the link with VBA is don’t work. Can you please tell me where I can take this VBA code?

Where can I get the command coding to send the email?? The larger macro

Hi Neil - I got one issue and i hope you can help. I have created the form inserted the button to submit the form, changed the wording and added the code. When i test it the code information gets lost. how can i stop this from happening

Thanks. How can i send the file created as word with macros in a shared folder on a local server with macro ?

Cool! It's worked but I need to to convert that code as PHP Is it possible Mr.Neil Malek ??

Hello, great video thank you for helping me out! I have a question, is it possible to create a form where one button submits the form... and when the person receives the form via email, he can press an approval or denial button on that same form that replies back to the original requester and all the CC: recipients so they know if the form was approved or denied? I'm just learning about macros. Appreciate your help! Thanks.

Can u confirm where u got your codes from.? I’m trying to create a Print Page button but I’m confused where to get the codes

Can you use the same macro for Power Point?

Hello sir Thank you very much for nice and easy explanation. I have a question about fields on MicroSoft Word? If i want to write a document to use it as a certification form in my school . The form has 3 fields of text content control , that i have to fill before sending to printer. The first field is student nam , the second is ID Name and last one is the class name. I want to add a command button inside the document that on click it do tow things. Save the file as the name of the student name field or as the student id in a specific directory. And print out the ducumet but without the shape of command button . Can you help me pleas how do write the code of this command button to do this work. Thanks in advanced.

Hello, I need a VB code within the submit button code that will send an email with person name whose name is on the form as a subject line. Help please .

the link in the description doesn't work! Can anyone help please?

Is it possible to make a command button to clear all the plain text fields. To avoid having to resend blank templates?

the larger macro however requires one to save it. What if I dont want to save that document.

Thanks for the video. How would you change the code to have it open a new message with the form attached but have it not send automatically? Before people submit the form I want to give them a chance to attach other files. Thxs

Awesome, I feel as if I am IT savvy!

Hi Neil, this is great tutorial which helps me a lot. A little more advanced, is there any way to have my subject line picks up value from one of form fields? if so, it is perfect for me. Thanks!

anyone know how to do this on a macbook since that option does not exist?

Where do you get the macros for the submit button for the submit button?

Can you please post the code? Im unable to read it all to create my form? thank you

Button works just fine on my Laptop but when I send it to coworkers they get Compile Error: Object or Library Not Found: (olMailItem)

+Natalie Aquino - looks like the problem is routing from Word through Outlook. The solution is to set .Importance to 2. www.mrexcel.com/forum/excel-questions/493086-auto-email-setting-importance.html