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
@robinadil43244 жыл бұрын
Very Useful Tutorial!!! Thanks for sharing!!! Very Well-explained!
@zedearl51813 жыл бұрын
Excellent tutorial. Future subscriber here 👏🏾
@tanchijeok3467 Жыл бұрын
An excellent video turned out, everything is well thought out, a very clear instruction turned out)))
@rorylitchfield4 жыл бұрын
this was a great help - thanks
@samphillips9201 Жыл бұрын
This helped a lot thank you
@paulcruz63754 жыл бұрын
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-ld2dk5 жыл бұрын
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?
@henryk26894 жыл бұрын
Thank you!
@jabarwocky2 ай бұрын
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
@davidjones53673 жыл бұрын
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 Жыл бұрын
Thank you so much :)
@BALAmoudi3 жыл бұрын
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
@kareno8003 жыл бұрын
Love it!! Is it possible to send an email with a link to the document ??
@mrlakuakua2 жыл бұрын
Thanks for the tutorial, how to do you set up the email client?
@Prokudak3 жыл бұрын
Great stuff. How to add code to send this form to a specific email?
@eza9962 Жыл бұрын
finally found thanks to the author
@djmatosdr Жыл бұрын
Best of the best
@tausifrahman89284 жыл бұрын
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
@gloveman35025 жыл бұрын
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!!!
@Awayzo5 жыл бұрын
You can add a mail to declaration to the button.
@killbill2x5 жыл бұрын
@@Awayzo How do you add a mail to declaration?
@Mzbreanna5 жыл бұрын
@@Awayzo Yeah thats really not helpful. I need step by step...
@myessence342 жыл бұрын
This was very helpful. How do I set it up where my email address will automatically pop up when they hit submit.
@danielrrivera51263 жыл бұрын
Good stuff
@m.n.9532 жыл бұрын
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.
@tuaparulian49754 жыл бұрын
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.
@Awayzo3 жыл бұрын
Great suggestion, I will put this on the list.
@youniqueboutique213411 ай бұрын
Wasn't that great. Never made the video lol
@enidvanniekerk5 жыл бұрын
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
@learnerscloud8965 жыл бұрын
The code would be the same in Excel. If you are using Excel Cells than it would simply reference the individual cells instead.
@centralindian2 жыл бұрын
Awesome
@SMFARHADUZZAMAN5 жыл бұрын
Please make a video about how to make GUID and put it inside ms office automatically/randomly
@skeeterburke3 жыл бұрын
what about making a form in Excel? I like the rows and columns, it helps me stay organized
@Awayzo3 жыл бұрын
This is a great suggestion. I will create a video on this...
@beebeenz5 жыл бұрын
Is there any way to submit form to an an email address on the form as well as a fixed one?
@learnerscloud8965 жыл бұрын
From what I think you are asking...You want to submit the form to an email address?
@deyenoren3876 жыл бұрын
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.
@learnerscloud8966 жыл бұрын
Check to see if you have the security setting on your word
@MissNicolaT5 жыл бұрын
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?
@Awayzo3 жыл бұрын
You should download a mail client like MailZilla
@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.
@bhavenmehta62664 жыл бұрын
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?
@chetas36556 жыл бұрын
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 ?
@Awayzo5 жыл бұрын
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.
@botrrun93992 жыл бұрын
is there a way to create a field and limit the number of words the field can contain i.e. 250 words?
@pXxDisasteRxXq2 жыл бұрын
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?
@Vieee073 жыл бұрын
How to choose file by using the way like submit?
@smutib28634 жыл бұрын
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
@ronskalit83845 жыл бұрын
how do you add a code to save it to a file instead?
@gupttura27664 жыл бұрын
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?
@ApolloDSouza6 жыл бұрын
does this work with gmail, yahoo, etc
@learnerscloud8966 жыл бұрын
Yes it does.
@pumaking24765 жыл бұрын
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
@Awayzo5 жыл бұрын
You can write VBA code that specifically opens the application you want in the SendMail Class
@richardburton7980 Жыл бұрын
Does it usualy take a while for emails sent like this to arrive at there destination
@kailiadr5 жыл бұрын
Is there code to generate the content in the email body and not as an attachment?
@Awayzo5 жыл бұрын
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 Жыл бұрын
So once they e received this what do they have to do to send it back filled in
@Mzbreanna5 жыл бұрын
So is it true activeX does not work on macs?
@learnerscloud8965 жыл бұрын
Yes. Macs do not have activeX
@yashodhanraut5 жыл бұрын
How to do this in Google docs?
@tomvetmadkins49822 жыл бұрын
Where do I insert the email I want the documents to go to?
@mahmoodalrashed30976 жыл бұрын
هل يمكن اضافة زر للطباعة ؟
@maxthepiguy36585 жыл бұрын
Mahmood Alrashed is asking if you can add a second button for printing...
@brittanydavis50304 жыл бұрын
My active x controls are grayed out what did I do wrong lol
@witchothewood4554 жыл бұрын
When I type in "Options" in Visual Basic, nothing pops up for me... is there a list I can choose from?
@Bagsandthingsbysilvia4 жыл бұрын
I was having the same problem but when I typed a full stop sign the selection list appeared. I hope that helps.
@Bagsandthingsbysilvia4 жыл бұрын
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.
@kristenkite17043 жыл бұрын
me too. i can t find a solution. :( if anyone knows do tell!
@MelCompton3 жыл бұрын
Hi Silvia. Did you get your form to work?
@richardburton7980 Жыл бұрын
Yeh I get to submit form and nothing happens when I click it any advice
@deegee676 жыл бұрын
How do you get it to work using gmail or yahoo.. When I follow, it only opens Outlook
@Awayzo5 жыл бұрын
I will make a video addressing this soon.
@charmedcharmed35113 жыл бұрын
@@Awayzo You made this comment 2 years ago... could we know when is "soon"?
@Englishpa4643 жыл бұрын
Clearly explained. However, I am not familiar with this tap.
@ajayprasadrout30863 жыл бұрын
HOW TO ATTACH EMAIL STEPS ARE NOT CLEAR AS TYPING IS NOT VISIBLE
@tala44843 жыл бұрын
I dont have a option button-
@Mike-P Жыл бұрын
+sub, workis
@brightonchou13933 жыл бұрын
most people got lost.
@loekeslagun1948 Жыл бұрын
Roses are red violets are blue you got click baited and i did too.