Microsoft Word: Create a Form with a Submit Button

  Рет қаралды 139,497

Learners Cloud

Learners Cloud

6 жыл бұрын

In this video, Malik demonstrates that you can easily attach a macro to a button, and have a document emailed to you.
Online Text Tutorial: www.techrepublic.com/blog/10-t...

Пікірлер: 83
@robinadil4324
@robinadil4324 4 жыл бұрын
Very Useful Tutorial!!! Thanks for sharing!!! Very Well-explained!
@zedearl5181
@zedearl5181 3 жыл бұрын
Excellent tutorial. Future subscriber here 👏🏾
@tanchijeok3467
@tanchijeok3467 Жыл бұрын
An excellent video turned out, everything is well thought out, a very clear instruction turned out)))
@rorylitchfield
@rorylitchfield 4 жыл бұрын
this was a great help - thanks
@samphillips9201
@samphillips9201 Жыл бұрын
This helped a lot thank you
@paulcruz6375
@paulcruz6375 4 жыл бұрын
Great tutorial! While writing the code for the submit button, Could I code in a couple of primary emails I would like this form to be submitted to and could I also have the form generate the person who is filling out the forms email automatically when the email client pops up? Thank You
@Aya-ld2dk
@Aya-ld2dk 5 жыл бұрын
Amazing it was very helpful ,thanks!! But if I wanna add many option buttons to the same question, how I will do it please b'cuz I make a form for my school and I need your help?
@henryk2689
@henryk2689 4 жыл бұрын
Thank you!
@jabarwocky
@jabarwocky 2 ай бұрын
Great video, easy to understand and follow like all your videos. The VBA works well with one email, but what do i do if i was sending to multiple email addresses or CC's
@davidjones5367
@davidjones5367 3 жыл бұрын
Hi I followed your tutorial and then saved my form before trying to email it out to potential ‘clients’. My form didn’t work with the reply button, although it did at my end. Also, the form proved tricky to open especially on a mobile phone. I am obviously doing something wrong, but I haven’t a clue what it is. Your advice would be greatly appreciated Kind regards David
@alexcardenas8614
@alexcardenas8614 Жыл бұрын
Thank you so much :)
@BALAmoudi
@BALAmoudi 3 жыл бұрын
Great presentation what about if i want to save this document in a separate folder? and i also want to name this document as in a text box1 how to write a command? Thanks in advance
@kareno800
@kareno800 3 жыл бұрын
Love it!! Is it possible to send an email with a link to the document ??
@mrlakuakua
@mrlakuakua 2 жыл бұрын
Thanks for the tutorial, how to do you set up the email client?
@Prokudak
@Prokudak 3 жыл бұрын
Great stuff. How to add code to send this form to a specific email?
@eza9962
@eza9962 Жыл бұрын
finally found thanks to the author
@djmatosdr
@djmatosdr Жыл бұрын
Best of the best
@tausifrahman8928
@tausifrahman8928 4 жыл бұрын
Hi, good video but the focus is one problem. In spite of trying hard, I could not get the syntax of Option command in the end. Can you please give the exact syntax. Thanks
@gloveman3502
@gloveman3502 5 жыл бұрын
How do we add in a specific email that the form will be sent to? Otherwise, awesome video! The battle between Microsoft and Adobe has made my office life difficult. This is a great work around!!!
@Awayzo
@Awayzo 5 жыл бұрын
You can add a mail to declaration to the button.
@killbill2x
@killbill2x 5 жыл бұрын
@@Awayzo How do you add a mail to declaration?
@Mzbreanna
@Mzbreanna 5 жыл бұрын
@@Awayzo Yeah thats really not helpful. I need step by step...
@myessence34
@myessence34 2 жыл бұрын
This was very helpful. How do I set it up where my email address will automatically pop up when they hit submit.
@danielrrivera5126
@danielrrivera5126 3 жыл бұрын
Good stuff
@m.n.953
@m.n.953 2 жыл бұрын
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.
@tuaparulian4975
@tuaparulian4975 4 жыл бұрын
It's very helpful. I've been searching for videos that show how we can set/limit the number of words and characters in a form in developer. Can you show a tutorial about this? I'd appreciate it. Thanks.
@Awayzo
@Awayzo 3 жыл бұрын
Great suggestion, I will put this on the list.
@youniqueboutique2134
@youniqueboutique2134 11 ай бұрын
Wasn't that great. Never made the video lol
@enidvanniekerk
@enidvanniekerk 5 жыл бұрын
This is a fantastic and easy to follow video. just one question, can I do this in excel and what would the code be to do this in excel? please help
@learnerscloud896
@learnerscloud896 5 жыл бұрын
The code would be the same in Excel. If you are using Excel Cells than it would simply reference the individual cells instead.
@centralindian
@centralindian 2 жыл бұрын
Awesome
@SMFARHADUZZAMAN
@SMFARHADUZZAMAN 5 жыл бұрын
Please make a video about how to make GUID and put it inside ms office automatically/randomly
@skeeterburke
@skeeterburke 3 жыл бұрын
what about making a form in Excel? I like the rows and columns, it helps me stay organized
@Awayzo
@Awayzo 3 жыл бұрын
This is a great suggestion. I will create a video on this...
@beebeenz
@beebeenz 5 жыл бұрын
Is there any way to submit form to an an email address on the form as well as a fixed one?
@learnerscloud896
@learnerscloud896 5 жыл бұрын
From what I think you are asking...You want to submit the form to an email address?
@deyenoren387
@deyenoren387 6 жыл бұрын
Thanks for the video! I have made one template but it doesn't work to be saved in Word-Template. Can you please help? What is possibly wrong? Thanks. I apreciate youe help.
@learnerscloud896
@learnerscloud896 6 жыл бұрын
Check to see if you have the security setting on your word
@MissNicolaT
@MissNicolaT 5 жыл бұрын
Great video. I'm having issues with the form actually being sent to an email address. I don't use Outlook, so how can i set this up for gmail?
@Awayzo
@Awayzo 3 жыл бұрын
You should download a mail client like MailZilla
@tutsecret499
@tutsecret499 Жыл бұрын
How do I send this form to different e-mails. I mean I fill out some results on the client form, and I press the submit for the form to be sent to specific client's email. Each form will have a client's name with their own e-mail. If can't do that, then I have to take photo of the form on the screen with the client's cell phone so that he knows his grade results, or lab test results, etc it replaces the old fashion 3 carbon copy slip to give the client the results on a hard copy slip.
@bhavenmehta6266
@bhavenmehta6266 4 жыл бұрын
I want to create a fillable form with submit button. On clicking the submit button the data filled should be transferred to a designated word file where I collect daily data. How can this happen?
@chetas3655
@chetas3655 6 жыл бұрын
can we create an approval process with this ? Like instead of submit we have approve button & we get that updated in the word document also ?
@Awayzo
@Awayzo 5 жыл бұрын
Yes, you can send all approvals to a gmail, access, or file text database. This is a great idea for a video. I may pursue this and create a video.
@botrrun9399
@botrrun9399 2 жыл бұрын
is there a way to create a field and limit the number of words the field can contain i.e. 250 words?
@pXxDisasteRxXq
@pXxDisasteRxXq 2 жыл бұрын
can't get a thing: if I go in Legacy -> Legacy Modules, I select Text Form Field and put one into the document. Then, it seems I can't insert any text in it. When I try to do it, the Text Form Field disappeared, as if I had deleted it. I need to calculate a macro on the exit of the Text Form Field, after editing the text into it, but I can't put any text in it. The standard Plain Text Controls haven't the "Calculate Macro On Exit" option, so I can't do what I need apparently. Could you help me?
@Vieee07
@Vieee07 3 жыл бұрын
How to choose file by using the way like submit?
@smutib2863
@smutib2863 4 жыл бұрын
What code can output the questions with the selected radio button option on a SEPARATE document. Ex. How are you? (X) Good ( ) Bad ------> click Submit ---------> How are you? Good
@ronskalit8384
@ronskalit8384 5 жыл бұрын
how do you add a code to save it to a file instead?
@gupttura2766
@gupttura2766 4 жыл бұрын
I created same button and everything..when I click on it I get run time error 424 Object Required Private Sub CommandButton1_Click() Options.SendMailAttach = True ActiveDocument.SendMail End Sub where line Options.SendMailAttach = True comes up highlighted in yellow!!! Not sure what is wrong? Can you help please?
@ApolloDSouza
@ApolloDSouza 6 жыл бұрын
does this work with gmail, yahoo, etc
@learnerscloud896
@learnerscloud896 6 жыл бұрын
Yes it does.
@pumaking2476
@pumaking2476 5 жыл бұрын
How do you get it to work using Windows 10 default Mail.. When I follow your coding it only opens Outlook which I dont use. Cheers
@Awayzo
@Awayzo 5 жыл бұрын
You can write VBA code that specifically opens the application you want in the SendMail Class
@richardburton7980
@richardburton7980 Жыл бұрын
Does it usualy take a while for emails sent like this to arrive at there destination
@kailiadr
@kailiadr 5 жыл бұрын
Is there code to generate the content in the email body and not as an attachment?
@Awayzo
@Awayzo 5 жыл бұрын
Yes, The Send mail function has the following arguments: expression. SendMail( _Recipients_ , _Subject_ , _ReturnReceipt_ ) So you would have to use something like this: Dim olMail As Outlook.MailItem ... olMail.HTMLBody = mail_body & "" & RangeToHtml.claim_info olMail.Send
@richardburton7980
@richardburton7980 Жыл бұрын
So once they e received this what do they have to do to send it back filled in
@Mzbreanna
@Mzbreanna 5 жыл бұрын
So is it true activeX does not work on macs?
@learnerscloud896
@learnerscloud896 5 жыл бұрын
Yes. Macs do not have activeX
@yashodhanraut
@yashodhanraut 5 жыл бұрын
How to do this in Google docs?
@tomvetmadkins4982
@tomvetmadkins4982 2 жыл бұрын
Where do I insert the email I want the documents to go to?
@mahmoodalrashed3097
@mahmoodalrashed3097 6 жыл бұрын
هل يمكن اضافة زر للطباعة ؟
@maxthepiguy3658
@maxthepiguy3658 5 жыл бұрын
Mahmood Alrashed is asking if you can add a second button for printing...
@brittanydavis5030
@brittanydavis5030 4 жыл бұрын
My active x controls are grayed out what did I do wrong lol
@witchothewood455
@witchothewood455 4 жыл бұрын
When I type in "Options" in Visual Basic, nothing pops up for me... is there a list I can choose from?
@Bagsandthingsbysilvia
@Bagsandthingsbysilvia 4 жыл бұрын
I was having the same problem but when I typed a full stop sign the selection list appeared. I hope that helps.
@Bagsandthingsbysilvia
@Bagsandthingsbysilvia 4 жыл бұрын
Not sure if this will be seen by the creator as I can see there hasn't been any replies lately. However, great video, thank you. I do have a question if anyone can answer this; I created the form however the email button worked for me when I created it but when I send the form to someone else it doesn't work.
@kristenkite1704
@kristenkite1704 3 жыл бұрын
me too. i can t find a solution. :( if anyone knows do tell!
@MelCompton
@MelCompton 3 жыл бұрын
Hi Silvia. Did you get your form to work?
@richardburton7980
@richardburton7980 Жыл бұрын
Yeh I get to submit form and nothing happens when I click it any advice
@deegee67
@deegee67 6 жыл бұрын
How do you get it to work using gmail or yahoo.. When I follow, it only opens Outlook
@Awayzo
@Awayzo 5 жыл бұрын
I will make a video addressing this soon.
@charmedcharmed3511
@charmedcharmed3511 3 жыл бұрын
@@Awayzo You made this comment 2 years ago... could we know when is "soon"?
@Englishpa464
@Englishpa464 3 жыл бұрын
Clearly explained. However, I am not familiar with this tap.
@ajayprasadrout3086
@ajayprasadrout3086 3 жыл бұрын
HOW TO ATTACH EMAIL STEPS ARE NOT CLEAR AS TYPING IS NOT VISIBLE
@tala4484
@tala4484 3 жыл бұрын
I dont have a option button-
@Mike-P
@Mike-P Жыл бұрын
+sub, workis
@brightonchou1393
@brightonchou1393 3 жыл бұрын
most people got lost.
@loekeslagun1948
@loekeslagun1948 Жыл бұрын
Roses are red violets are blue you got click baited and i did too.
@Esp1fs
@Esp1fs 5 жыл бұрын
Widest screen I even seen on KZfaq
@learnerscloud896
@learnerscloud896 5 жыл бұрын
Thanks for watching
@chegobocanegra3703
@chegobocanegra3703 Жыл бұрын
finally found thanks to the author
How to create a fillable form with a submit button in Word
10:46
Melissa Compton
Рет қаралды 94 М.
3M❤️ #thankyou #shorts
00:16
ウエスP -Mr Uekusa- Wes-P
Рет қаралды 14 МЛН
Nutella bro sis family Challenge 😋
00:31
Mr. Clabik
Рет қаралды 12 МЛН
Happy 4th of July 😂
00:12
Pink Shirt Girl
Рет қаралды 60 МЛН
How to Insert a Clickable Checkbox in Microsoft Word
4:29
Office Master Tutorials
Рет қаралды 471 М.
Microsoft Word: Create a Submit Form Button
4:25
Neil Malek
Рет қаралды 220 М.
How to make Fillable Form in Microsoft Word
12:00
Kevin Stratvert
Рет қаралды 1,6 МЛН
Creating a quick database with Microsoft Word
10:29
Tech for Senior
Рет қаралды 21 М.
Advanced Microsoft Word - Formatting Your Document
10:18
Technology for Teachers and Students
Рет қаралды 2,1 МЛН
Create a Dynamic Fillable Form in Word to Capture User Input
24:11
Officeinstructor
Рет қаралды 38 М.
How to create a Gantt chart in Power BI (with a free visual!)
13:14
Christine Payton
Рет қаралды 48 М.
who is the champion of ludo luck balloon popping race ?
0:59
SS FOOD CHALLENGE
Рет қаралды 28 МЛН
ВЕЛОСИПЕД ЗАГОВОРИЛ
0:15
KINO KAIF
Рет қаралды 14 МЛН
ВЕЛОСИПЕД ЗАГОВОРИЛ
0:15
KINO KAIF
Рет қаралды 14 МЛН
devil Pk jesus 😱❤️😈#devil #jesus #shorts
0:15
Jesus Vs thank Devil
Рет қаралды 10 МЛН
Порезал бассейн, краш тест
0:32
ЗВЕРЬЕ
Рет қаралды 4 МЛН
Порезал бассейн, краш тест
0:32
ЗВЕРЬЕ
Рет қаралды 4 МЛН
Smart Appliances! New Gadgets, Versatile Utensils, Tool Items #shorts #gadgets 149
0:15