Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-10-2023, 06:22 PM
lisamarie lisamarie is offline Cant get the submit button to open outlook Windows 11 Cant get the submit button to open outlook Office 2021
Novice
Cant get the submit button to open outlook
 
Join Date: Dec 2023
Posts: 1
lisamarie is on a distinguished road
Default Cant get the submit button to open outlook

I have created my submit button, and entered the following code, however the outlook is not opening, so I cant send my form

Private Sub SubmitButton1_Click()
Label1.Visible = True
Dim OL As Object
Dim EmailItem As Object
Dim Doc As Document

Application.ScreenUpdating = False
Set OL = CreateObject("Outlook.Application")
Set EmailItem = OL.CreateItem(olMailItem)
Set Doc = ActiveDocument
Doc.Save

With EmailItem
.Subject = "Complaint Form submitted"
.Body = "Please find attached complaint form"
.To = "dog.info@pncc.govt.nz"
.Importance = olImportanceNormal
.Attachments.Add Doc.FullName
.Send
End With

Application.ScreenUpdating = True



Set Doc = Nothing
Set OL = Nothing
Set EmailItem = Nothing
End Sub
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with submit button to email form JoeFreeman Word VBA 1 01-28-2023 05:20 PM
VBA Code For Submit Button stu_c Word VBA 3 09-10-2018 04:37 AM
Cant get the submit button to open outlook Submit Button Req that populates email address phorsley Word VBA 1 10-17-2017 04:50 PM
Submit to Email Command Button rob7676 Word VBA 0 08-20-2015 05:05 AM
Cant get the submit button to open outlook VBA Code for a SUBMIT button in a Word form BlueMax Word VBA 3 08-07-2013 06:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft