How to create a fillable form with a submit button in Word

Тәжірибелік нұсқаулар және стиль

​In this tutorial you’ll learn how to create a fillable form with a submit button in Word. I've included the visual basic script in the description below so you can use it during that step.
SOFTWARE:
melcompton.com/recommends/adobe/
GEAR:
Lenovo ThinkPad Laptop: amzn.to/2NvXTGU
Dell Monitors: amzn.to/3r0iwte
VIVO Dual Monitor Mount Stand: amzn.to/3bBmJ0f
Logitech Wireless Mouse and Keyboard: amzn.to/2OX7V4g
Powered USB Hub: amzn.to/3bBmCBR
Focusrite Scarlett Solo: amzn.to/3aMzIwV
Audio-Technica Headset: amzn.to/2Np3Qpl
WC Wicked Cushions Replacement Earpads: amzn.to/3uoihuh
LET’S CONNECT:
Facebook: / therealmelcompton
Twitter: / melissaecompton
LinkedIn: / melissa-compton-17701240
Instagram: / melissaacompton
NOTE: This description contains affiliate links, which means at no additional cost to you, I will receive a small commission if you make a purchase using the links. This helps support the channel and allows me to continue making videos like this. Thank you for your support!
***VISUAL BASIC CODE FOR SUBMIT BUTTON**
Be sure to change the .subject, .body and .to so it will work for you.
Dim xOutlookObj As Object
Dim xEmail As Object
Dim xDoc As Document
Application.ScreenUpdating = False
Set xOutlookObj = CreateObject("Outlook.Application")
Set xEmail = xOutlookObj.CreateItem(olMailItem)
Set xDoc = ActiveDocument
xDoc.Save
With xEmail
.Subject = "Test Email"
.Body = "This is a test email for submit button"
.To = "youremail@email.com"
.Importance = olImportanceNormal
.Attachments.Add xDoc.FullName
.Display
End With
Set xDoc = Nothing
Set xEmail = Nothing
Set xOutlookObj = Nothing
Application.ScreenUpdating = True
End Sub

Пікірлер: 192

  • @primetimeofnebraska4994
    @primetimeofnebraska4994 Жыл бұрын

    Loved the video. Once the form is made, do you email it to your person to fill it out as an attachment and then they open it, fill it out and hit the submit button and it comes back to you?

  • @MelCompton

    @MelCompton

    Жыл бұрын

    Hello! Yes, you email it to the person as an attachment. They save it to their local machine, open it fill it out, and when they click the submit button it will fire off Outlook. If they experience issues check with your IT department to see if they have it locked down.

  • @stephanieannmassewilliams5221
    @stephanieannmassewilliams52212 жыл бұрын

    Thank you for this tutorial! I've watched a few and by far I have liked this one the most. I found that the pace in which you spoke and the tone of your voice made it easy to understand. The visual turotial was also easy to follow. Now, I will go put it to the test! I've now subscribed and I will look forward to you being my 'Go to' for such tutorials. Thank you!

  • @simondou6882
    @simondou68822 жыл бұрын

    Awesome video, really helped me understand how to modify fillable forms with active submit button. Thank you.

  • @theadventuresofembrunguy2825
    @theadventuresofembrunguy28252 жыл бұрын

    That was highly informative. Great job. Thank you Melissa.

  • @dflayvorent6564
    @dflayvorent65642 жыл бұрын

    Very detailed, Awesome, Great job, very clear and understanding, Thank you for you wonderful information to help others. 😘

  • @dr.c.c.1671
    @dr.c.c.16712 жыл бұрын

    Superb! PLEASE continue to make these types of tutorials. You are great at it!!!!

  • @cynthiakerford4458
    @cynthiakerford44583 жыл бұрын

    This was AWESOME! Concise, well paced, on point with the explanations of the functions and what to expect when activating the buttons. Most of all thank you for the Visual Basic Script! I am building new client forms for my Travel Agency. Just a suggestion to change the background from a black to maybe a grey. Questions will these forms launch if someone opens them on their cell phone to complete? I will also test from my end. THANK YOU!!!!!

  • @ThePsalmfive11

    @ThePsalmfive11

    3 жыл бұрын

    Following

  • @ritaadams2980
    @ritaadams29802 жыл бұрын

    You are a brilliant teacher. God bless you for this. It has helped me a great deal.😘😘👏👏👌

  • @sonyaserrano5839
    @sonyaserrano58392 жыл бұрын

    Excellent video! Thank you so much

  • @brendacannon3062
    @brendacannon30622 жыл бұрын

    This is so awesome! Thank you!

  • @shelliebesharse7007
    @shelliebesharse70072 жыл бұрын

    This video was extremely helpful. I have watched it numerous times and now have the confidence to move ahead. I could not find the Visual Basic information, however, so I could copy that for my document. Where is the description link to copy the script? Excited about finding your videos for future review.

  • @jessie_marreel
    @jessie_marreel7 ай бұрын

    Thank you for the tutorial! It was super helpful and easy to follow!

  • @stephenlepage
    @stephenlepage2 жыл бұрын

    Great Tutorial. P.S. Congratulations on 1K subscribers. 🙂

  • @RHaddadzadeh
    @RHaddadzadeh11 ай бұрын

    Thanks a lot for your great tutorial. Very useful!

  • @meyanyusuf312
    @meyanyusuf3122 жыл бұрын

    Thank you much, very brief and informative

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    Glad it was helpful!

  • @dawitafewerki
    @dawitafewerki Жыл бұрын

    nice, direct and easy. will definitely go for more of ur tutorials.

  • @MelCompton

    @MelCompton

    Жыл бұрын

    Thank you! Glad it helped!

  • @remorrey
    @remorrey2 жыл бұрын

    This is absolutely fantastic. I've been struggling with Acrobat's equivalent form capability for THREE days. Before giving up trying to send a form to all our family reunion attendees, I found your AWESOME tutorial! Thank you so much. PS. Although I've already successfully tested it, I'd like to use a link that gives you a reward. Which one do I use?

  • @MelCompton

    @MelCompton

    Жыл бұрын

    Hi Richard. Sorry for the delayed response. If you are still interested there is a "thanks" button at the top. If not, no worries at all. I'm glad this helped you.

  • @bepicky
    @bepicky2 жыл бұрын

    Thank you for this awesome explanation. As always there is just one thing. Editing restrictions will not let me select any other options other than read only. I'm not in design mode. I think I followed your instructions. Haw can I fix this?

  • @jbmyerov
    @jbmyerov2 жыл бұрын

    Thank you for this tutorial! It's saving me big time. In the VBA, is there a way to add spaces for the body of the default email? I have a standard message that should go with all forms, but it requires a little paragraph break.

  • @stephencaffera

    @stephencaffera

    2 жыл бұрын

    If you want to break to a new line in the body of the email, all you have to do with the VBA code is use the vbCrLf token. This is the standard new-line token defined in VBA. In the "With xEmail" block, you'll have to change the code for the Body property to something like this: .Body = "First line of text." + vbCrLf + "Second line of text"

  • @brilliantskinesthetics
    @brilliantskinesthetics Жыл бұрын

    This is soooooo amazing! Thank you

  • @MelCompton

    @MelCompton

    Жыл бұрын

    Thank you! I'm glad it helped!

  • @ibnashadanik4345
    @ibnashadanik43452 жыл бұрын

    Thanks

  • @jashaundacollins6391
    @jashaundacollins6391 Жыл бұрын

    Thank you for this video!!!! It saved me, lol. I have Microsoft 22 and my developer tab does not look like the one in the video. Would you happen to know where I can find the legacy tab/panel in Microsoft 22?

  • @shelliebesharse7007
    @shelliebesharse70072 жыл бұрын

    Melissa, found the script! My oversight.

  • @festusatembil6076

    @festusatembil6076

    2 жыл бұрын

    Please where is it

  • @RonaldEJones-cd3fr
    @RonaldEJones-cd3fr2 жыл бұрын

    Excellent tutorial. My question is, what if I have a long document and at the end of the document (last page) I have an application or reply page and I only want the client to complete this last page to send with the submit button, can that be done and if so how? Thanks,

  • @oxnardcollegecurriculum4815
    @oxnardcollegecurriculum48154 ай бұрын

    This was really helpful, thank you! Is there a way around the docM file extension? Our organization blocks them for security reasons. I read somewhere that you could put it in a zip folder. Is there anyway to include that in the visual basic code? So that it would attach the file in a zip folder instead of just the file?

  • @MsMRBEER
    @MsMRBEER Жыл бұрын

    I found your tutorial very useful. I would like to be able to create a multi page form where some information is carried over from the first page to subsequent pages (I.e. member number and first and last name) without having to enter said information multiple times. Recommendations please.

  • @MelCompton

    @MelCompton

    Жыл бұрын

    Hello! I will get a tutorial out on how to do this as soon as I can.

  • @DOJ77
    @DOJ772 жыл бұрын

    Great video, thank you for sharing. Can someone tell me how to edit the form after I have done all these steps?

  • @m.n.953
    @m.n.9532 жыл бұрын

    HELLO THANKS FOR NICE EXPLANATION. in fact i need some thing semelar . i write a form for my school and i need a macro for the command button to save the form as the content of student name field, or ID number field. so how can i write the code for the button to call the text from the field of the text box and save the file as this text, pleas you help

  • @jabarwocky
    @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

  • @bretryan463
    @bretryan4639 ай бұрын

    Thank You for doing this. You are a gifted teacher. I was not able to get this to work and received a popup window - "BASIC runtime error. "323" Module cannot be loaded; invalid format. This popup appeared on top of the script page with line 8 highlighted in blue. How do I fix this? Thank You - Great Job!

  • @godfreyoyasotie9824
    @godfreyoyasotie98249 ай бұрын

    Hi Melissa, thank you for this video tutorial. However, I would like to ask you how do I share the form with customers so they can complete it at their end and when they are done, it comes back to me in a word or PDF format? Also, can I insert E-signature functionality? Your response will be highly appreciated.

  • @dawoodmoiz
    @dawoodmoiz2 жыл бұрын

    Great video, Melissa! Quick question. Can this button be used to save the document in pdf and then attach to the email? Thank you in advance.

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    Hello! Are you wanting to use the PDF as a fill in form?

  • @scottquinn5537
    @scottquinn5537 Жыл бұрын

    Great tutorial. If I want to the "submit" to email more than one person, do I need two lines of script for email, or is there a way to write more than one email address into the ".To" line?

  • @MelCompton

    @MelCompton

    Жыл бұрын

    Hello! No you can separate them by a comma.

  • @cyrilrussell2513
    @cyrilrussell25133 жыл бұрын

    This is a great tutorial. Thanks so much. When I test the submit button myself, Outlook loads just fine to send the form. When I send the form to someone to complete, when they hit submit, they are prompted to save the document before sending and I would prefer that not happen. Do you know why that would be happening and how to prevent it? Thanks so much!

  • @ThePsalmfive11

    @ThePsalmfive11

    3 жыл бұрын

    Following

  • @lucillefigueroa3971

    @lucillefigueroa3971

    2 жыл бұрын

    I have the same error. What would be the workaround for it?

  • @catherinemills958

    @catherinemills958

    2 жыл бұрын

    Any answers or workarounds discovered?

  • @wandalee7972

    @wandalee7972

    2 жыл бұрын

    Anyone get an answer to this I am getting the same error

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    Hi everyone. If they are being prompted to save it then I would check with your IT department. Since there is VB script and ActiveX Controls some IT departments lock it down because virus's can be sent that way.

  • @aaronemptage1448
    @aaronemptage14486 ай бұрын

    This is exactly what I was after for my form thank you. Is there a way to be able to use any type of email system not just outlook please?

  • @andrewlee3625
    @andrewlee36252 жыл бұрын

    Can you save the form as pdf format and still have the Submit button functioning?

  • @Kriss-bx2rl
    @Kriss-bx2rl3 жыл бұрын

    Thank you, easy to understand. Encountering an error, debug 429 Active component can't create object. I am using Outlook for emails, have signed off and re entered survey with same results. Triple checked programming with same results. Can you advise please?

  • @MelCompton

    @MelCompton

    3 жыл бұрын

    Hi Kriss, this error is usually due to a corrupt file in the active x controls. You could try telling the ActiveX control to start via services.msc. If you have an IT department I would recommend you let them do it for you. If this doesn't work then they would have to reinstall some of the services.

  • @ryanrealsola860
    @ryanrealsola860 Жыл бұрын

    Thank you for the Tutorial! If I wanted to send the entire template in the email body rather than an attachment how would I do that?

  • @MelCompton

    @MelCompton

    Жыл бұрын

    Hello! Just out of curiosity why would you want to do that? Just so I get an idea of expectations.

  • @12MiTT
    @12MiTT2 жыл бұрын

    Thank you for the effort, it is very nice of you. I have encountered an email issue when use it through organization email! It thinks it has infected with malware or it is a malware itself!!.. Is there a work around solution?? Thanks in advance :)

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    Hi Sam. This is not malware. Please check with your IT department. Some of them will lock down office so it can't run VB Script or ActiveX Controls.

  • @ramyamohan5451
    @ramyamohan5451 Жыл бұрын

    Hey Melissa, thank you for this tutorial, I found it very helpful. Everything works however, once the form is submitted it save the filled form and override the blank form. Is there a way in which people can submit the form but it reverts the a blank form for next time?

  • @MelCompton

    @MelCompton

    Жыл бұрын

    With a little bit of VBA magic. I will get it researched and an update put out as soon as I can.

  • @lauriepayne6100

    @lauriepayne6100

    Жыл бұрын

    Great Question, this is my question also!

  • @user-mn5hf6cp3x
    @user-mn5hf6cp3x Жыл бұрын

    Hi Melissa. This was a very helpful tutorial. I HAVE JUST ONE QUESTION : How to export the filled details in online excelsheet or google form? - as I don't want to email it further but to save the details as an excelsheet.

  • @MelCompton

    @MelCompton

    Жыл бұрын

    If you are wanting to get the information into a spreadsheet or google form I would not recommend using this method. I would create a form via Microsoft 365 online. This will allow you to pull the information in. If they person does not have a Microsoft 365 account they can still fill out the form but you must include a place for them to put in their name. Here is a tutorial on how to use forms. studio.kzread.infox8hqxLLnq-o/edit

  • @user-mn5hf6cp3x

    @user-mn5hf6cp3x

    Жыл бұрын

    @@MelCompton Thanks. That was a great help!

  • @kbing10
    @kbing102 жыл бұрын

    Can I make forms that can be signed?

  • @calhouncountypublichealth1352
    @calhouncountypublichealth13522 жыл бұрын

    i can't get the drop down to work.. looks like it does on my end but when i send it they can't see that.. nor is the submit working

  • @darlalandaal8535
    @darlalandaal85352 жыл бұрын

    Thank you for the video! We appreciate the help. We are running into an issue and I'm sure it is an easy fix, but I can't find it. When a person submits the document, but do not have a MS email account, it will not send. They receive "No valid email accounts are configured. Add an account to send mail" Is there a way to fix this? Thank you Melissa!

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    Hello! This is only compatible with MS email accounts. If you are working with someone who uses Gmail I would recommend using Google forms.

  • @alfonzoowens5893
    @alfonzoowens58932 жыл бұрын

    Thank you for the informative tutorial! I am new to this. I am designing a form to submit for my church which does not use outlook. Do I place gmail wherever outlook ls in the vba text? Thank you so much!

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    Hello! this is not compatible with Gmail. It only works with Microsoft accounts. If you are working with someone using Gmail I would recommend creating a form through Google forms.

  • @alfonzoowens5893

    @alfonzoowens5893

    2 жыл бұрын

    @@MelCompton Thank you.

  • @alfonzoowens5893

    @alfonzoowens5893

    2 жыл бұрын

    @@MelCompton Thank you

  • @UMEmilyCichon
    @UMEmilyCichon Жыл бұрын

    Great tutorial! How do you go back in there to edit? Mine locked me out completely.

  • @MelCompton

    @MelCompton

    Жыл бұрын

    Hello! You should be able to follow the steps from where we first put the code in to make changes.

  • @kayderr460
    @kayderr4602 жыл бұрын

    How do you keep the form once submitted to not be submitted again if accidentally clicked once it has been submitted? Does that make sense?

  • @wendylarson8847
    @wendylarson88472 жыл бұрын

    Can a signature be added?

  • @nickiwilliamson3590
    @nickiwilliamson35903 жыл бұрын

    This is very informative thank you. I'm working on O365 and have created form, submit button and all appears to work, apart from, the email is not being received after pressing the submit button. The email window pops up, with the form attached, no error message when I click on 'Send' but email has disappeared! Any ideas? Appreciate your help.

  • @MelCompton

    @MelCompton

    3 жыл бұрын

    Hi Nicki! Is the email address correct in the “to” field in the VB script?

  • @nickiwilliamson3590

    @nickiwilliamson3590

    3 жыл бұрын

    @@MelCompton Hi - it certainly is!! I've since spoken with our IT Department, and we have security features that don't allow macro enables docs to be sent or received :( I think I'll see if I can create a PDF form - it's years since I've done one, but I don't think they use macros. Thanks again though - your videos are great and I will keep watching! Cheers, Nicki

  • @MelCompton

    @MelCompton

    3 жыл бұрын

    @@nickiwilliamson3590 that’s too bad but I get it. If they will allow you to use Google docs you can do it through there too. There is a video on my channel on how to do it. It also logs the responses and doesn’t use macros. :)

  • @mikeferretti7422
    @mikeferretti7422 Жыл бұрын

    Thoughts on being able to have a submit button to go to specific dept or person based on their response.

  • @MelCompton

    @MelCompton

    Жыл бұрын

    Hello! This type of workflow responses might be better handled by Microsoft 365 online using forms.

  • @mikeferretti7422

    @mikeferretti7422

    Жыл бұрын

    @@MelCompton isn't it still pretty much like google forms very basic? I know Jotform can handle this but isn't easy to create.

  • @MelCompton

    @MelCompton

    Жыл бұрын

    @@mikeferretti7422 when it first came out yes it was basic but not anymore. I will put out a forms tutorial as soon as I can. It has workflow management and everything now.

  • @ThePsalmfive11
    @ThePsalmfive113 жыл бұрын

    Thank you for this tutorial! When I sent a test email, I was able to download it and fill in the blanks; but the "Submit" button would not work. What could I be doing wrong? It gave me a security notice with the option of disabling macros or enabling them. Which is best?

  • @MelCompton

    @MelCompton

    3 жыл бұрын

    Hello! The submit button won’t work unless the macros are enabled. However, some IT departments have it locked so they can’t be enabled.

  • @chriscrans9332

    @chriscrans9332

    2 жыл бұрын

    I have the same problem. I think the recipient has to save the attachment first. AND they have to be smart enough to save it as a macro-enabled document. Then they can work from a saved version. If they fill the form directly from Outlook, the submit button will be buggy. I find this whole thing disappointing. I think PDF fillable form is better. I worked on my annual reviews for employees forever. Tested it 20 times on my two computers. Got it to work. Sent it to all my employees--and immediately got flooded with emails that they couldn't get the submit button to work, and "why do I have to run a debugger?" and "do I have to save it with macros?" and "what are macros?" etc. I felt stupid.

  • @pamelatrent9674

    @pamelatrent9674

    2 жыл бұрын

    @@chriscrans9332 I just tried it and on my own computer it worked perfectly, then I forwarded the document to my assistant to see if it worked for her. Same issue--it required her to save the document. now that i see you had the same issue, this may not work for me. I was hoping it would.

  • @wandalee7972

    @wandalee7972

    2 жыл бұрын

    @@pamelatrent9674 did you get an answer on how to fix this error?

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    @@chriscrans9332 They should not have to save it as a macro enabled workbook. Most times this issue is a result of IT locking it down because it's VB Script and Active X Controls.

  • @MsSaz90
    @MsSaz902 жыл бұрын

    Hi Melissa and thank you for your video. Everything worked until i sent out the forms. When the reciver are trying to fill the forms and click on the submit buttion, then the submit buttom wont work. It just goes to "save file". Do you know why this happens?

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    Hello! This is a script that runs so check with IT to make sure they have access for macros, scripts and active X controls to run. Sometimes IT has this locked down.

  • @jobmail9341
    @jobmail93412 жыл бұрын

    Hi, Awsome! Will this work online within office 365 and not only with desktop apps?

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    This can be used online with office 365. However, if you have office 365 I would recommend using forms instead of this method. Here is an overview of MS Forms in Office 365. kzread.info/dash/bejne/qmyc09qFfNHXXdI.html

  • @jeanpainter6657
    @jeanpainter6657 Жыл бұрын

    When I double click on a legacy text input box and set parameters to only allow a length of 10, I can still type an unlimited number of charachters in that box. How can I constrain the size of the box so it retains the format of the form?

  • @MelCompton

    @MelCompton

    Жыл бұрын

    If you go into the properties of the text box it should let you restrict the character limit.

  • @ishraelkongona6564
    @ishraelkongona6564 Жыл бұрын

    Hi Melissa, Couldn't locate the VB Script on the comments. If you could help. Thanks.

  • @dsapadin
    @dsapadin Жыл бұрын

    How is the email being sent? Does it default to whatever your WIndows default email APP is, such as GMAIL or Outlook? If Outlook what if you have 4 profiles in there. What if you send this form to 20 people and they all have different email APPS as their defaul? SOMETHING has to send the email + the attachment, and I don't see anything nor did I hear any discussion about how that is going to happen. Thanks! Appreciate what you're doing here!!!!

  • @MelCompton

    @MelCompton

    Жыл бұрын

    Hello! This is only compatible with MS Outlook. You and all your recipients must have MS Outlook. To do this with other apps I would recommend doing it through office 365 on line or LibreOffice.

  • @composing-chaos
    @composing-chaos2 жыл бұрын

    How can I create a place for them to insert an image?

  • @paulnonnenmann2738
    @paulnonnenmann27383 жыл бұрын

    When I run the debug there's an error at this line - Application.ScreenUpdating = False. The word "false" is highlighted and the error message reads "Invalid outside procedure". How do you fix that? When I change to "True" I get the same message.

  • @paulnonnenmann2738

    @paulnonnenmann2738

    3 жыл бұрын

    Okay, I got by the first bug. Now the error is on line .Attachments.Add xDoc.FullName. Any thoughts on this one?

  • @MelCompton

    @MelCompton

    3 жыл бұрын

    @@paulnonnenmann2738 Hi! Did you save it as a macro enabled document?

  • @gerritcross9806
    @gerritcross98062 ай бұрын

    Loved the video and great content however My checkbox does not line up with the text next to it. How do I fix this, please

  • @wendyshuler3547
    @wendyshuler354711 ай бұрын

    Is there a way to complete fillable form and data goes into excel spreadsheet?

  • @patrickrobinsonphotography2699
    @patrickrobinsonphotography2699 Жыл бұрын

    Hi, I'm wanting to create an application form that allows for uploading images and/or documents as well. Is this possible?

  • @MelCompton

    @MelCompton

    Жыл бұрын

    Hello! If you are wanting tracking as well this might be better done in Microsoft 365 online using forms.

  • @pamelatrent9674
    @pamelatrent96742 жыл бұрын

    I don't see the script...perhaps by now it's buried pretty deep in the comments?

  • @asheniahaydel7514
    @asheniahaydel75142 жыл бұрын

    I'm using a MacBook Pro and my screen looks a little different. I don't have the active X controls option to do the submit button. Any idea on how I can still do this?

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    Hello! ActiveX is a programming application for Windows based computers only. This solution will not work on a Mac. I would recommend creating a form through Adobe Pro DC or Google Forms.

  • @chloesmith7313
    @chloesmith7313 Жыл бұрын

    Hello Melissa, Great video. I do have a question. I seem to be having issues with the code. Do you think maybe the code has been updated? I copied and paste the exact code in the description but still not working. When i ran the code , error came from this line Application.ScreenUpdating = False I changed the parameters but still won;t work

  • @MelCompton

    @MelCompton

    Жыл бұрын

    Hello! What is the error you are getting for this line of code?

  • @msmissymorales2438
    @msmissymorales2438 Жыл бұрын

    very helpful video. hi ms Meslissa. im using gmail account . dont use outlook. how can i change the visual basic script

  • @MelCompton

    @MelCompton

    Жыл бұрын

    Hello! This is only compatible with Microsoft Outlook. Both the sender and receiver must have Outlook installed on their local machine. Since you are using Gmail, I would recommend using forms through Google apps.

  • @msmissymorales2438

    @msmissymorales2438

    Жыл бұрын

    @@MelCompton thnx and more power to your channel.

  • @kimcastro2253
    @kimcastro22532 жыл бұрын

    I am having an error :-( I have sent it to myself and opened it on another computer. The error says "Microsoft Visual Basic for Applications Compile error: Cant find project or library" Please help!

  • @shelliebesharse7007
    @shelliebesharse70072 жыл бұрын

    Melissa, in the VB code you provided, how do I list a gmail account instead of every instance of Outlook? I would appreciate a reply ASAP. Also, since the video is over a year old, does the all the VB script remain the same and will it still work? Shellie

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    Hi Sheila. This is only compatible with outlook. If you are working with Gmail accounts I would recommend using Google forms.

  • @shelliebesharse7007

    @shelliebesharse7007

    2 жыл бұрын

    @@MelCompton I appreciate your prompt reply. As I have already created the Physical Therapy consent form in MSWord and spent hours watching videos and learning about the "Developer" Tool, I may try to find someone to write the VB script I need to use in the document. Thank you, Melissa!

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    @@shelliebesharse7007 It's not that I won't write the script for it. It's that it doesn't exist. VB script is not compatible with Gmail. VB is specific to Microsoft. Gmail is Google and they have their own form system. So, it's a software incompatibility issue.

  • @shelliebesharse7007

    @shelliebesharse7007

    2 жыл бұрын

    @@MelCompton Thank you for clarifying regarding VB and it association with Microsoft. I have also watched videos on using Adobe Acrobat Pro to complete forms. As I mentioned previously, I have created a very good Treatment Consent form in MS Word with the Developer tools. The intended goal was, and still may be, to email the Treatment Consent form Word file to patients prior to coming for their first visit. I guess they could fill out the form in Word, assuming they have Word, and attach and send back to the clinic. If I save the Word document as a .pdf, I would still have to edit with Adobe Acrobat. I guess I will give up on the SUBMIT button, but it sure would have enhanced the document and made it easy for patients to reply. I could save the current document with a different name, take out all the form fillers, save as a .pdf, and try Adobe Acrobat Pro. Never used that either but am willing to learn it as well. Do you have experience with Adobe Acrobat and is my suggestion something to consider? Look forward to watching more of your videos. Thank you, Melissa!

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    @@shelliebesharse7007 If you have Adobe Pro DC then save it as a PDF and add fill in text boxes. They can then fill it out and send it back to you. You could have them fill and sign via Acrobat Pro and automate the process a little. I do work with Adobe Pro DC and this would be a good tutorial topic as an alternative to Word and Google Forms.

  • @internationalfellowshipofw4956
    @internationalfellowshipofw49562 жыл бұрын

    How to get the visual basic script you just pasted?

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    The visual basic script used is in the description. You can copy and paste it from there.

  • @calhouncountypublichealth1352
    @calhouncountypublichealth13522 жыл бұрын

    also how is it to be saved to be sent to others? I sent it to test and it is my version lol

  • @chriscrans9332
    @chriscrans93322 жыл бұрын

    When I send this form, my recipient fills the form and hits submit. They are then asked to save the file. They are then told they cannot save it because it's a "read only" file and a debugging dialogue opens up. But this will be wonderful if it can work.

  • @chriscrans9332

    @chriscrans9332

    2 жыл бұрын

    ah. this doesn't happen if they download the form. But if they open it directly from Outlook, then it is opened without being saved? Then clicking on the submit button does a buggy thing to try to save it.

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    @@chriscrans9332 They should not have to save it as a macro enabled workbook. Most times this issue is a result of IT locking it down because it's VB Script and Active X Controls.

  • @MasterSelfLove
    @MasterSelfLove Жыл бұрын

    Hello, I am so confused when you say "CONTROL V, I would get a visual basic script from a comment". What comment? I have a contract that I have written and I used fillable boxes, when I click Control V a sentence from my document post in that area. I just want to email it, but WORD won't allow me to email it, so I came across your video, which I love this concept of SUBMIT. However once I double click the SUBMIT BUTTON..... I'm not getting what you are getting.

  • @MelCompton

    @MelCompton

    Жыл бұрын

    Hello! The VBA script is in the description. You can copy it from there an paste it into Word.

  • @marielkelinske1689
    @marielkelinske16892 жыл бұрын

    Hi! How can I add 2 emails instead of one? Thank you!

  • @marielkelinske1689

    @marielkelinske1689

    2 жыл бұрын

    Never mind… my company disabled macros for security reasons 😩

  • @danielrrivera5126
    @danielrrivera51263 жыл бұрын

    This was great. Just the black color scheme is a bit too dark for a tutorial with multiple steps.

  • @MelCompton

    @MelCompton

    3 жыл бұрын

    Thank you so much for your feedback. I’ve added a large highlighted cursor to help with this. If you watch one of my recent tutorials and don’t think it makes it better please let me know and I will make more adjustments. Again, thank you for letting me know.

  • @larrythelepp
    @larrythelepp Жыл бұрын

    Hi, will these forms work on smart phones/android/apple or only on PC? They seem distorted on mobile devices

  • @MelCompton

    @MelCompton

    Жыл бұрын

    Hello! No they will not work correctly on mobile devices.

  • @mswallace6615

    @mswallace6615

    11 ай бұрын

    @@MelComptonwould this work on smart phones if it were a pdf file instead of a word document?

  • @MENTR4U
    @MENTR4U Жыл бұрын

    I got the form to work perfectly on my computer, however, it is not working on the other end. It doesn't work if it is saved in google docs. Please suggest a solution - thanks!!

  • @MelCompton

    @MelCompton

    Жыл бұрын

    This is not compatible with Google Docs. Only Microsoft Office. If you have a google user I would recommend creating a form in Google Workspace.

  • @kissandracollins9933
    @kissandracollins99332 жыл бұрын

    I did not add a password when restricting the document but now I can't edit the form. How do I "unlock" the document to edit?

  • @sharontaylor9848

    @sharontaylor9848

    2 жыл бұрын

    Just discovered this myself Kissandra - had the same problem. There's a very small button in the bottom right-hand corner (jprobably designed to not be easily visible) to 'remove protection'. You can then edit again.

  • @mylaraye-artist189
    @mylaraye-artist1894 ай бұрын

    how do we send to people to fill it out? & each time i save the format changes

  • @raghubirsangha7212
    @raghubirsangha7212 Жыл бұрын

    I want to learn to make a table with submit and reset button and How to save data in other sheet

  • @MelCompton

    @MelCompton

    Жыл бұрын

    Hello! Are you wanting a fillable form in Word or Excel?

  • @stacymyers3314
    @stacymyers33142 жыл бұрын

    For some reason I cannot type in my text box. The curser will go in front of the box or behind the box but not in the box - what am I doing wrong?

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    Hi Stacy. What are you trying to type into the box? Is it during the set up or after it's saved?

  • @rebeccahamstra1304
    @rebeccahamstra13042 жыл бұрын

    These two lines keep coming up as needing "debugging" before I can activate the "submit" button. What do I need to change here? Set xOutlookObj = CreateObject("Outlook.Application") Set xEmail = xOutlookObj.CreateItem(olMailItem)

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    Hello! are you using Outlook? It is only compatible with MS Outlook.

  • @rebeccahamstra1304

    @rebeccahamstra1304

    2 жыл бұрын

    @@MelCompton I was trying to use my gmail account but I have an Outlook email account also. I will try that. Thanks

  • @rebeccahamstra1304

    @rebeccahamstra1304

    2 жыл бұрын

    I'm still having problems because it wants to use my old work email address to verify my identity and that account has been closed for over 2 years now. It won't accept my personal outlook email I think because the old work email was through Microsoft 365. What should I do?

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    @@rebeccahamstra1304 Do you have a Microsoft365 subscription for your personal outlook address? If you don't then this will not work.

  • @DJMNMR
    @DJMNMR2 жыл бұрын

    I think I got it all correct but when I click submit it goes to outlook and I use gmail and nothing is working to change that

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    Hi Donna. This will only work with outlook. If you need to do something similar with Gmail I recommend using Google forms. I have an older video on how to do that here. kzread.info/dash/bejne/iquXsZawdafTcag.html

  • @dr.c.c.1671
    @dr.c.c.16712 жыл бұрын

    Hi again, I do not use outlook for mail, I use Gmail. Would you be kind enough to show me the code for that rather than outlook? How would I change the code you have already so kindly shared?

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    Currently, you can not invoke Gmail from MS Word. I would recommend using Google Forms instead.

  • @dr.c.c.1671

    @dr.c.c.1671

    2 жыл бұрын

    @@MelCompton Thank you for responding. that helps!

  • @fatimalatif-qx8sd
    @fatimalatif-qx8sdАй бұрын

    I cant change BODY and email etc. It says compile error.

  • @ElowinSky
    @ElowinSky Жыл бұрын

    I don’t see a “Developer” tab!

  • @subhojitdas6146
    @subhojitdas61462 жыл бұрын

    Wouldn't using Google forms be much easier option?

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    Some people use Microsoft, some Google and some libreoffice. I cover them all. People need to use what’s best for them or what their company mandates. Have a great day!

  • @kenberry9987
    @kenberry99873 жыл бұрын

    I'm getting the following error message: Set xOutlookObj = CreateObject("Outlook.Application")

  • @MelCompton

    @MelCompton

    3 жыл бұрын

    Hi ken! When are you getting this error? After you've saved everything and then go in and use the submit button?

  • @kenberry9987

    @kenberry9987

    3 жыл бұрын

    Hi Melissa and thanks, when I select the button I get "Run Time Error 49 ActiveX component cannot create object - I then run Debug and get that message

  • @MelCompton

    @MelCompton

    3 жыл бұрын

    @@kenberry9987 a run time error 49 is an error with the COM (component object model) and is usually computer specific. I hate to sound like a typical IT person, but once you save the document as a macro enabled doc please close outlook on your desktop and either reopen it or leave closed. Then reopen the word document and try to submit it again. I get notified when you respond so I'm here to see if we can fix it.

  • @kenberry9987

    @kenberry9987

    3 жыл бұрын

    I've just realised that I'm not using Outlook, I'm actually using Mozilla Firefox, I guess that could be the problem :-(

  • @MelCompton

    @MelCompton

    3 жыл бұрын

    @@kenberry9987 yes, that is the problem. I apologize. I assumed you were using outlook on your desktop. That should have been my first question. :( Are you using office365 or Mozilla Thunderbird?

  • @pamelatrent9674
    @pamelatrent96742 жыл бұрын

    Just found it on the side there...

  • @krisschmitz2167
    @krisschmitz2167 Жыл бұрын

    I get an error, "Invalid outside procedure" How do I correct this.

  • @MelCompton

    @MelCompton

    Жыл бұрын

    Hello! Are you getting it on compile or where?

  • @RowanGolightly
    @RowanGolightly6 ай бұрын

    I'm working on a sample survey form in Microsoft 365, trying to teach myself. There is no menu ribbon, only the rectangle of 9 dots in the lefthand corner. Their 'help' is not helpful and only shows me their templates. There is no one here I can ask.

  • @MelCompton

    @MelCompton

    6 ай бұрын

    Are you using the online version or desktop version of Microsoft 365?

  • @joancoble8065
    @joancoble80653 ай бұрын

    Need help...if i want to use Gmail for the submit address and not Outlook, what code should i use? Thanks!

  • @MelCompton

    @MelCompton

    3 ай бұрын

    This is not compatible with gmail. I would recommend using Google forms.

  • @AhmedIbrahimIBRA
    @AhmedIbrahimIBRA Жыл бұрын

    how to add an upload file to the form

  • @johnbrancato7729
    @johnbrancato7729 Жыл бұрын

    Hmmm I clearly did something very wrong none of this worked for me :(

  • @parawinhauskuksolution9490
    @parawinhauskuksolution94902 жыл бұрын

    Tried, but was still unsuccessful. Cannot work for Gmail account maybe : Set xEmail = xOutlookObj.CreateItem(olMailItem)

  • @MelCompton

    @MelCompton

    2 жыл бұрын

    Hello! This only works with outlook. If you need to do this with Gmail I recommend using Google forms.

Келесі