Probably some of the most helpful videos on KZread about ms office. Simple, well done, straight to the point, all around awesome.

@SharonSmith

3 жыл бұрын

Thank you so much! Thanks for watching and taking time to leave such a nice comment. I really appreciate it!

You don't know how much I appreciate your content. I'm passing my IT projects so well. Thank you!

@SharonSmith

2 жыл бұрын

I'm so glad to hear that!! Very happy that my videos have helped you. Thanks for watching!

I wish I saw your videos before I spend so much time trying to figure out how to do forms on my own. These tutorials are much better then some classes I have taken. Thank you

@SharonSmith

2 жыл бұрын

That is so great to hear, Luis! I'm very glad you found my videos helpful. Thanks so much for watching!

Thank you so much for this video Sharon! This is definitely a tool I will be using often.

@SharonSmith

4 жыл бұрын

I'm glad you found it useful! Thanks so much for taking time to leave a comment!

Thank You so much for entering the command in the description. It saved me so much time.

@SharonSmith

3 жыл бұрын

Glad to help! Thanks for watching my videos!

Excellent tutorial Sharon, just what I needed to submit online forms to my email address. Thank you 😊

@SharonSmith

3 жыл бұрын

Hi Zed! You are very welcome, and Thank You so much for watching!

Truly helpful! Such a lucid explanation and illustration. Thanks a million!

@SharonSmith

2 жыл бұрын

Thank you! I'm glad you found it helpful. Thanks for watching!

Excellent Directions!! Thanks So much!!!!!!!

A REAL TREASURE !!!!! Thank you Sharon!

@SharonSmith

2 жыл бұрын

Glad you found it helpful! Thanks so much for watching and subscribing to my channel!

Love your videos - thank you so much.

@SharonSmith

3 жыл бұрын

You are very welcome, Christopher! Thanks for watching!

Thank you Sharon, it worked first time.

@SharonSmith

2 жыл бұрын

Great to hear! Thanks for watching!

Excellent video. Thank you Sharon. You are the best!!

@SharonSmith

3 жыл бұрын

Thanks so much! Glad you found it helpful. Thanks for watching my videos!

Hi! I looove you! I am brand new to macros. I was a straight pdf person until you opened my eyes and I realized there's more to word when creating forms. You are very clear and helpful with posting the codes. Please! Create a video that shows how to hide a command button when I print the word document but is always visible when filling the form. I will wait for this information as long as it takes. My office and I needs this! Lol thank you for your hard work!

@SharonSmith

3 жыл бұрын

Thank you so much!! I'm glad to hear you like my videos! This can be done in Word, but requires some additional VBA code. If you create your form in Excel, there is an easier option to edit the properties of the command button so that it won't print. I'll be working on these videos. Thanks for watching! Take care!

Brilliant! Thank you!

@SharonSmith

3 жыл бұрын

You are very welcome, Mike! Thanks for watching!

These videos are amazing, thank you ! Quick question ....can you add more than one email address when programming the submit button?

Thank you so much for this video!

@SharonSmith

3 жыл бұрын

You are very welcome! Thanks for watching!

Wow, it's amazing. I would like to say thanks a million.

@SharonSmith

3 жыл бұрын

Thanks so much for watching my videos and for the kind feedback! Take care!

Great tutorial Sarah, thanks to you I've created my first fillable form that can now be submitted

@SharonSmith

3 жыл бұрын

Great news! Glad to hear my videos have helped you out, Denis. Thanks for watching!

@enriquecano8805

Жыл бұрын

Sharon I love the way explain things. Unfortunately I have figured how to see the links to to videos to copy certain things which would make things a lot easier. Please keep posting great job.

This worked great! Thank You!

@SharonSmith

2 жыл бұрын

Glad you found it helpful, Nate! Thanks for watching!

My hero. So helpful and pleasant. Thank you!

@SharonSmith

2 жыл бұрын

Thank you for the kind words, Dawn! So glad you like my videos. Thanks for watching!

Very helpful - thank you!

@SharonSmith

2 жыл бұрын

Glad to help! Thanks for watching!

You're making me look good at work! Thank you for all your help. Love your videos!

@SharonSmith

4 ай бұрын

So glad to hear that! I'm happy you are finding my videos helpful. Thanks for watching!

Very informative video for me, Thanks Sharon

@SharonSmith

3 жыл бұрын

You are very welcome, Kashif! Thanks so much for watching my videos!

Thanks this was really useful, I'll be watching more

@SharonSmith

3 жыл бұрын

Hi Paul, that is great! Thanks so much for watching my videos. I have a Playlist (kzread.info/dash/bejne/i5-ovJV7XdffodY.html) on how to create fillable forms that you may find helpful as well as other helpful videos on my channel if you have a chance to review and watch. Take care!

The presentation is very informative and the ideas are easy to follow

@SharonSmith

3 жыл бұрын

Thanks for watching, Eaton! So glad you found my videos helpful!

Sharon, your tutorials are the best. They are very helpful. By any chance - do you have any tutorial that shows how to change the document name with the content of filled in content control field? I want to receive forms from people with the name of each person in the file name. Thank you in advance!

This is a game changer! Thank you!

@SharonSmith

2 жыл бұрын

So glad you found it helpful. Thanks for watching!

thank you so much, this was really useful

@SharonSmith

3 жыл бұрын

You are welcome! Very glad you found it helpful. Thanks so much for watching!

Fantastic! That's just what I needed. Thank you so much. 🥰

@SharonSmith

Жыл бұрын

Glad to help! Thanks for watching!

Thank you very much. Your tutorial was very helpful to me

@SharonSmith

2 жыл бұрын

Glad you found it helpful! Thanks for watching!

Excellent video! How do we go about inserting the form into the body of the email as opposed to it being an attachment?

The best video, thank you so much.

@SharonSmith

Жыл бұрын

Glad you found it helpful, Sarah! Thanks for watching!

You are wonderful!

@SharonSmith

3 жыл бұрын

Thank you so much Raysa! Thanks for watching my videos!

Awesome! thanks!

@SharonSmith

Жыл бұрын

Glad you found the video helpful, Amy! Thank for watching my channel!

Hi Sarah. Thank you for the wonderful videos you put out. Much appreciated. I am running windows10 and did all the right things where the email was sent off but I did not receive the test email on my personal computer. Could I have missed a step or is there a fix?

Excellent Tutorial..Thanks Mam 😊I have created one and got an accolade from my management

First time I seen vba in word file...thank you

@SharonSmith

3 жыл бұрын

Thank you for watching!

Thanks you From Germany

@SharonSmith

3 жыл бұрын

You are very welcome! Thank you for watching my videos!

This is very cool, I will try this. thanks

@SharonSmith

3 жыл бұрын

Hope it works for you! Thanks for watching!

Thank you , This is very useful for me :)

@SharonSmith

3 жыл бұрын

You are welcome! Thank you for watching!

Great information.

@SharonSmith

2 жыл бұрын

Glad you found it helpful! Thanks for watching!

Hi, I discovered your tutorials when looking for information on how to create forms in Word, OUTSTANDING!! My question is can the form be submitted in the body of the email as opposed to an attachment? I created an incident form using your form creation video and would like for it to be sent in the body to make it easy for supervisors to view on their phones (mostly) or tablets without dealing with an attachment. Thank you, Jack

Hi Sharon, Just found the link to this video and others and immediately subscribed. The way you present the topic is fantastic, short and simple, but with all the information needed for that topic. It has made me think about the many uses that I can put these ideas to within my school. However, I do have a couple of questions based around the document that I want to create; 1) I want to set up a document for 'special leave request', therefore a template would be ideal as it is reusable. However, would I be able to have a SUBMIT button on a template document? 2) after the document is submitted I want to have a part on the template for 'office use only' This is where the recipient (manager) can approve the request / cancel the request / ask for more information. Is this possible all in one template? 3) Finally I would like to be able to 'save' the final document to an employees digital HR file. Is this as simple as clicking on SAVE AS? Going to review your videos just in case I have missed something, just play with them and test them out. Thank you.

Awesome!

@SharonSmith

4 жыл бұрын

Hi Kate! Thanks so much for watching and taking time to leave a comment! I appreciate it!

EXCELLENT!!!!!!!!!

@SharonSmith

2 жыл бұрын

Thanks, Scott! Glad you found it helpful. Thanks for subscribing to my channel and watching my videos!

I can never thank you enough, Sarah. Can I use this also to clear the form fields?

@SharonSmith

3 жыл бұрын

Thank you so much for watching! I may have sent this to you already, but here is a video that shows how you can save your form as a Template which will clear the form fields so users can re-use the form: kzread.info/dash/bejne/ma6I15ZvXb2bmJM.html Take care!

Hi Sharon, love the tutorials! Is there a way of hiding sections throughout a fillable form?

@SharonSmith

3 жыл бұрын

Hi Wendy! There are ways to do this...I'll have to work on a video for this topic. Thanks for watching!!

Thank you so much for your informative videos! I'm trying to create a form for my clients to get confidential information. How can I send an enabled macro word document to clients without them having to enable all macros from the settings?

Your videos have been so helpful Sharon. How do you turn on your ActiveX controls if it’s disabled? Also, for forms already created with Submit button, how do you edit the email destination?

Thank you

@SharonSmith

3 жыл бұрын

You are very welcome, Cara! Thanks for watching my videos!

First - thank you for all your videos! By far - the best teaching platform I have come across! I have created my fillable form with a submit button. What I need to do now is to save this form as a template. My crew tends to reuse this form and that leads to fields being completed incorrectly. Templates prevent them from reusing an already completed form. My problem occurs when I save as a template, my submit button no longer works correctly. I have searched high & low - with no luck. Your thoughts are greatly appreciated! Thank you!

@SharonSmith

3 ай бұрын

Hello! I'm so glad you like my videos! Unfortunately when you save your form as a template file type (.dotx or .dotm), the behavior of ActiveX controls might change due to security restrictions. There are settings you can modify to test it, but it is not recommended as it makes your settings more vulnerable. A workaround would be to insert a "Clear Form / Reset Form" button somewhere on your form. So instead of saving it as a template file type, you can leave it as a .docm file type. You can insert and place the button (ActiveX Command Button) anywhere on your document and program it similarly to how you did the Submit button, but you would use this code instead: Private Sub CommandButton1_Click() Dim cc As ContentControl Dim ff As field ' Unprotect the document to allow form field entry If ActiveDocument.ProtectionType wdNoProtection Then ActiveDocument.Unprotect End If ' Clear content control form fields For Each cc In ActiveDocument.ContentControls Select Case cc.Type Case wdContentControlText ' Text content control cc.Range.Text = "" Case wdContentControlComboBox ' Combo box content control cc.Range.Text = "" Case wdContentControlDate ' Date picker content control cc.Range.Text = "" ' Clear the date value by setting the Range.Text property to an empty string Case wdContentControlCheckBox ' Checkbox content control cc.Checked = False ' Uncheck the checkbox End Select Next cc ' Reset legacy form fields ActiveDocument.ResetFormFields ' Protect the document again if needed If ActiveDocument.ProtectionType = wdNoProtection Then ' Replace "YourPassword" with the actual password if your document is password-protected ActiveDocument.Protect Type:=wdAllowOnlyFormFields, NoReset:=True End If End Sub This will work to clear/reset Legacy Form fields (Text boxes, Checkboxes & Drop-downs - it will reset the drop-down to the first item available in your list, so you may want to set that to "Please Select") and it will also reset Content Control form fields for Plain Text, Checkbox, ComboBox, and Date Picker. I recommend testing this out and if it works for you, then you can give users instructions on your form to hit the clear button prior to filling in the form. I hope this helps! Thanks for watching my videos!

Yu said it: helpful tips.

@SharonSmith

3 жыл бұрын

Thank you for watching, Dennis! Glad you found it helpful!

Excellent information! My only wish is that the code could be written to open the users default email account. Any ideas? Thanks for your efforts and Happy New Year!

Your tips are absolutely a life saver! Is there a way to send a fillable word template response to specific recipients based on a response given in a form? Ex: if you answered that you work in this dept, or this is supervisor, the email would go to that group instead of 1 email address for all responses. Thanks I’m advance.

tks for this video. It has been great and I have now want to set up a form with the submit button on it. However, as a non profit group we have 300+ members. do all the forms come in thru the email and how do you collage them at all. I wondered if i might need to use mailchimp or something like that as we would like to use it as almost a database of members

Hi Sharon, great tutorials! I would like to make a button that is "Print" to a local/ network printer. How?

Thank you so much Sharon for sharing your knowledge. God bless you abundantly. I got it working with my word doc form was in unprotected mode, but didnt work when I protected the document. Did I miss something? Thankyou for your help🙏😇

Thanks Sharon. I was able to set up a mandatory field as you demonstrated, however my field is towards the end of my form. I found that the macro won’t trigger unless the user tabs through that field, so if they use a mouse to click a field past it. Any fix to that, perhaps a warning when they try to save?

Hi Sharon, thanks for all the great videos. How can I get a button to reset all form fields to blank in MS Word?

@SharonSmith

3 жыл бұрын

Hi Kerry! You can do that through more advanced VBA code, but an easier way is to save your document as a "Template" file type. I did a video on how to make your fillable form re-usable: kzread.info/dash/bejne/ma6I15ZvXb2bmJM.html Hope you find this helpful! Thanks so much for watching!

Hi Sharon - great videos! I'm looking same idea with the button but I want when clicked that it prints a form. Cannot seem to find the VBA Code for that options. Thanks!

Well needless to say this is an EXCELLENT video! But I have a question that goes a little deeper; how do I paste the body of the word document into the email body instead of attaching the document to email? For our group we order chemicals throughout the week and using your technique they currently see an attached document. It would be easier if they could just see it in the body of the email. Thank you for the excellent training!

Hello. Very simple and easy to follow. Anyway you can get the form to be emailed as a PDF?

I have successfully applied all your wonderful and helpful guides to finally have a fillable form submit to email. but wondering how can I attach another document to that same email please. Love your tutorials so very very helpful

thank you for such great instructions. if I want to make (to) in VBA dynamic not depending on one email. like I want to make dropdown list for emails then I need the VBA to send according to my selection ... is it possible ?

I absolutely love your video, and easily added the Submit button at the bottom of my fillable Word Document... If I open the document on my desktop, I can easily open it, fill it in, and send it to myself... But I am having trouble when I share it with other users (who also use Outlook, but through various servers) - it makes them save the form, the form is not fillable on their end, or it goes into "debug" with xdoc.save being the culprit. Any advise?

@SharonSmith

3 жыл бұрын

Hi Emily! This could be due to having a macro-enabled document file type. Sometimes end users may have IT security restrictions accessing macro-enabled documents. Is there any way you can check with your IT department? Hope this helps! Thanks so much for watching my videos.

GREAT VIDEO THANK YOU 😊 Is there a code to add to this, where the Subject Header for the email is dependent on what is selscted on the drop down box?

i'd probably have failed i.t if not for this video, thanks so much!

@SharonSmith

11 ай бұрын

Glad to help! Thanks for watching!

Hello Sharon! Is there a way to do multiple command buttons - one to send to people who need to e-sign the form and one for them to forward to recipients once all have e-signed?

Hi Sharon, thanks a lot for sharing this tutorial. It's really very informative and helpful. However, I have some problem. When I tried filling up the form and pressed submit, the pop-up menu did not appear at all. If you could help me resolve this, I'd be happy and grateful.

Hey Sharon, thank you very much for this tutorial, it has been very helpful to me. Is it possible to send just any one page from a document, for example, with three pages, via email by clicking a button?

Hello, Thank you so much for the informative tutorial. I have the same question as Dodd. My church uses gmail. Do I place “gmail”wherever “outlook” appears on the vba script?

Great video, thanks Sharon. I've just now completed a form for a local consultation, and included a 'submit' button for the forms to get back to our email address. I have a query for you - if people do not have Outlook, is there something in the code that I can change so that their usual email client is used (such as MS Mail or Gmail)?

@sulaimanrameez9912

2 жыл бұрын

Same question 🙈

@annaj1320

Жыл бұрын

Has someone figured it out? :D

@tomdodd3186

Жыл бұрын

@@annaj1320 I didn’t get a response here, and unfortunately couldn’t find a solution. Good luck!

Hi Sharon - thank you for all your videos. QQ: My submit button is not opening up outlook. I've copied and pasted the code and updated the email and subject line. Not sure what to do next.

Thank you Sharon, helped me a lot! Can the submit button be modified to work with firms using Google Email?

@SharonSmith

3 жыл бұрын

Hi Cynthia! Glad you found this video helpful. The VBA code we used in this video will only work with MS Office, so if you use Outlook as your email client, it will work. Hope this helps. Thanks so much for watching!

@onyebuchiadiuku8953

3 жыл бұрын

@@SharonSmith please how can I get the VB code you used please

@SharonSmith

3 жыл бұрын

Hello. Below the video on KZread, click SHOW MORE to expand the description below the video. The VBA code is there in the description. Thanks for watching!

Mrs. Smith, Thanks for sharing your knowledge. I have a few questions; hopefully, you can answer them or point me in the right direction. 1. How can we have the client rename the form with their name, so I know who submitted the form, without opening the attachment? 2. Does the form you used in the example, update on one master copy of the form? 3. If the form’s master copy does not automatically update, how can we create a workflow to automatically update or merge all the responses? Thanks for the assist.

@SharonSmith

4 жыл бұрын

Hi Charles! 1. I'm not sure how you would do that automatically, so would have to defer to giving the users instructions and hope they would follow them so that either they could rename the document or add their name to the Subject of the email before they send it. 2. & 3. That was just a static sample form. There are ways you can program a Macro in Excel to go and pull data out of multiple Word form documents and place them all in one spreadsheet. However, I would recommend considering Google Forms or SurveyMonkey as alternatives if you have a complex need or need to gather feedback from a lot of respondents as those platforms do the data "heavy lifting" without you having to worry about writing Macros in Visual Basic. You can try saving your completed Word form document as a text file (.txt) and then open Excel, go to Data > Get & Transform Data > From Text/CSV. If you used a delimiter in your form like a colon between the question and the form field, this will automatically pull your form data into Excel and open the Power Query tool if you need to transform the data. I hope some of this helps you out! Thanks so much for watching and taking time to leave a comment. Take care!

Hi Sharon! I'd love to see how to take the command button one step further in word. I'd like the button to first do a Save As to a pdf of my document so I can choose where to save it, and THEN add the PDF version as the attachment to my email. Thoughts?

💕

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.

@SharonSmith

2 ай бұрын

Thank you! To modify the VBA code so that it can send emails to multiple recipients and include CC and BCC addresses, you need to adjust the properties of the xEmail object within the With block. Specifically, you can add email addresses to the .To, .CC, and .BCC properties. Here’s how you can update the code to include multiple email addresses and CC recipients: Private Sub CommandButton1_Click() 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 = "Include your own Subject" .Body = "Include your own verbiage for email body text." .To = "recipient1@example.com; recipient2@example.com; recipient3@example.com" .CC = "ccrecipient1@example.com; ccrecipient2@example.com" .BCC = "bccrecipient1@example.com" .Importance = olImportanceNormal .Attachments.Add xDoc.FullName .Display ' Use .Send to directly send the email without displaying it End With Set xDoc = Nothing Set xEmail = Nothing Set xOutlookObj = Nothing Application.ScreenUpdating = True End Sub Explanation: Multiple Recipients in .To, .CC, and .BCC: The .To, .CC, and .BCC properties accept a string of email addresses separated by semicolons (;). Example for .To: "recipient1@example.com; recipient2@example.com; recipient3@example.com" Similarly for .CC and .BCC. Application.ScreenUpdating: This is used to prevent the screen from updating while the macro runs, which can make the process faster and prevent flickering. Set xOutlookObj = CreateObject("Outlook.Application"): This creates an instance of the Outlook application. Set xEmail = xOutlookObj.CreateItem(olMailItem): This creates a new email item. Set xDoc = ActiveDocument: This gets the currently active Word document. xDoc.Save: This saves the active document before attaching it to the email. Email Properties: .Subject sets the subject of the email. .Body sets the body text of the email. .Attachments.Add xDoc.FullName attaches the current document to the email. Display or Send Email: .Display shows the email to the user before sending it. If you want to send the email without displaying it, use .Send instead of .Display. Cleaning Up: Setting objects to Nothing releases the memory allocated for them. By following these steps, you can send an email to multiple recipients and include CC and BCC addresses as needed. Please test this to ensure it works properly for your needs. Take care!

Nice clear instructions Sharon. Unfortunately the submit button doesn't work. Its got something to do with my Outlook email not being set up. So will this not work with gmail? Help please!

Hi Sharon, what happens if the person submitting the form is t an Outlook user? Is there any code that will just open their default email program? This really was a helpful video… many thanks 🙏🏼

how can i make e mail subject equals to a certain text field in the document so i can recognize easily when sent

Thanks a lot for your highly informative videos, they are really helpful. Concerning the submit button, I've completed everything as you've instructed; however, the email did not reach its destination (to me). Please help me with this issue. Many thanks with due regards.

@SharonSmith

3 жыл бұрын

Hello! Just to confirm, are you using MS Outlook as your email client? This code is specifically for use with MS Outlook. I hope this helps! Thanks for watching my videos!

Real Cool thank you. Is there a way to have the doc sent from each individual have something in the name so you can quickly delineate between who's belongs to who? basically if you have 15 of these coming your way and I'm guessing they will all have same document name, is just easier to download and save it adding that individuals name - or you have a trick for that being done prior?

@SharonSmith

3 жыл бұрын

Hello! If I come across a shortcut for this, I will let you know. Otherwise you may optionally give users instructions to add their name to the subject of the email that will help you identify these quicker and hopefully your users follow instructions. Thanks so much for watching my videos. Hope this helps!

Plz, make a video on " creating a dropdown list of images" in word form filling. Thanks for your wonderful work.

@SharonSmith

Жыл бұрын

Hello - here is a video that shows how you can link images to appear based on a drop-down selection. The drop-down has a list item, but based on a user's selection, a different image can appear. Hope this helps! Thanks for watching my channel! kzread.info/dash/bejne/h3l8x7auppjad5M.html

Really Really Informative! But I wanted to use the gmail instead of outlook how can I use Gmail will you please provide the coding for it tooo.

Thank you for the tutorials 👍🏿👍🏿 I have tried the procedure but it turns to document when send to the user ... Kindly help out

What VBA code would I insert to send the completed form to my Gmail and not an Outlook account? Thanks for your help! You video was very useful!

Hi Sharon - great video and extremely helpful. I completed everything, hit my submit button and the email comes up, hit send but it never delivers. I am using MS Outlook 365. Please help! :)

Amazing!! How to use it for Gmail? Or is there a way to save the data automatically into Excel document? Please help

@SharonSmith

3 жыл бұрын

Hi Shivani! The VBA code in this video only works for MS Outlook as an email client. There are ways you can transfer data from a Word form to Excel. I am working on a video on this topic. Thanks so much for watching!

Hi Sharon, I love the videos, has helped me many times. Looking at the Submit video, is there a way to interject a date in the Subject, as the document I'm sending is date specific.

@SharonSmith

4 ай бұрын

Hello - Yes, you can inject the "current date" into the subject of the email by modifying the .Subject property of the xEmail object. You can use the Format function to format the current date according to your desired format. Here's how you can modify your code to include the current date in the subject: Private Sub CommandButton1_Click() Dim xOutlookObj As Object Dim xEmail As Object Dim xDoc As Document Dim currentDate As String Application.ScreenUpdating = False Set xOutlookObj = CreateObject("Outlook.Application") Set xEmail = xOutlookObj.CreateItem(olMailItem) Set xDoc = ActiveDocument xDoc.Save ' Get the current date and format it currentDate = Format(Date, "dd/MM/yyyy") ' Change the format as per your preference With xEmail .Subject = "Report - " & currentDate ' Modify subject to include the current date .Body = "Include your own verbiage for email body text." .To = "youremailaddress@youremail.com" .Importance = olImportanceNormal .Attachments.Add xDoc.FullName .Display End With Set xDoc = Nothing Set xEmail = Nothing Set xOutlookObj = Nothing Application.ScreenUpdating = True End Sub This should append the current date to the subject of the email in the format specified. Adjust the date format in the Format function according to your preference. Please be sure to test this to ensure it works for you. Hope this helps! Thanks for watching!

Hi Sharon, will you consider showing how to perform this action using the Mac version of Word? (I ask because I wasn't able find the command button; however, in the Visual Basic editor, there is language in one of the dialogue boxes for manipulation of a command button in Object Browser)

Do you know is it possible to have there be an option to what person or dept the form goes to when clicking submit either by a drop down or based on their selections?

This is very helpful. I have added the VBA code and changed the criteria as you have mentioned. When I select submit the correct information shows that I entered in. The issue is that when I select submit the email is going to my personal in box and is not being sent to the email address that I have entered in the VBA code. Any suggestions? I am using MS Outlook for my email.

@SharonSmith

3 жыл бұрын

Hi Katie, just to confirm you used this code below and replaced the ".To=" line with a different email address (not your personal email?). Also, just to confirm the other address is not set up with any rules to route to your personal inbox, correct? Private Sub CommandButton1_Click() 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 = "Include your own Subject" .Body = "Include your own verbiage for email body text." .To = "youremailaddress@youremail.com" .Importance = olImportanceNormal .Attachments.Add xDoc.FullName .Display End With Set xDoc = Nothing Set xEmail = Nothing Set xOutlookObj = Nothing Application.ScreenUpdating = True End Sub Hoping I can help you troubleshoot. Thanks for watching my videos!

This is exactly the function I'm looking for. Will the Submit Form Button work if you save this file as a pdf? Thanks.

@SharonSmith

3 жыл бұрын

Hello! Glad you found this helpful. I don't believe it will work if the document is saved as a PDF file type. Thanks for watching!

Your video is great and very helpful, however, I need the submit button to send in gmail not outlook, could you please provide the code for that?

Thank you!! Overall your video helped me tremendously! I am getting an error message when I attempt to compete my form (test). The message states Microsoft Visual Basic for Applications. Compile error: Syntax error. Any advice? Thanks!

Excellent tutorials! However, I have a question: how to program the button to send via Gmail (or any other email service like Yahoomail etc)?

@rociolopez-rocha7943

3 жыл бұрын

Was there an answer to your question? I am trying to figure this out too.

@fphrigian8183

3 жыл бұрын

@@rociolopez-rocha7943 Not yet, still trying to figure this out, too!

@blueeyesgirl2633

2 жыл бұрын

Has anyone had any luck with this yet?

Hi Sharon Your videos are very helpful. when you save the fillable form with the submit button do you safe the file as a doc file? also how to you in corporate after submit to clear all the fields on the original folder that will be on website. kind regards Michael

Thank you for your video! It was very helpful! I am having an issue though! I have emailed my form to the folks that would need to use the form. Once they complete it, when they hit send, it is giving them the Save Doc screen instead of just emailing to the given email address. If they hit cancel (and don’t save, which I do not want them to do each time they use the form) they get the debug pop up and the xDoc.Save line is highlighted. How do i just get the form to send the email and not require the save step?

@SharonSmith

4 жыл бұрын

Hi Jennifer! Do you know if your users happen to use MS Outlook as their default email? The VBA code in this video works for users who have MS Outlook as their email client. If so, let me know and I'll try and troubleshoot further. Thanks so much for watching my videos!

@jenniferhanwell9374

4 жыл бұрын

Sharon Smith, thank you! Yes, we use MS Outlook. I’m wondering if there is a blocker associated with the email as it is for a public school system???

@shanetrahan8224

3 жыл бұрын

I am having the same issue, the form is requiring the end user to save the document before sending???

Hi Sharon, any idea if the word developer have an option of inserting equations? thanks in advance!

@SharonSmith

3 жыл бұрын

Hi Rexielle! Here is a video I did on "Calculating" form fields (how you can insert equations using legacy tools form fields: kzread.info/dash/bejne/f6KnrsqDqtTTobw.html I hope this helps you out! Thanks so much for watching my videos. Take care!