![]() |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
hello everyone.
I am hoping someone can help in finding a solution to this error message I keep getting with running the following code: 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 = "Assessment Form" .Body = "Please find the assessment form attached. Thank you." .To = "testemailaddress@gmail.com" .Importance = olImportanceNormal .Attachments.Add xDoc.FullName .Display End With Set xDoc = Nothing Set xEmail = Nothing Set xOutlookObj = Nothing Application.ScreenUpdating = True End Sub ***Note: I don't have outlook on the computer I am using. I do have Mail and other email apps. Is there a way I can at least test my save and submit button by using other email other than outlook? thank you |
Tags |
help please, run-time error 429, send form by email |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Getting Run Time error 429: ActiveX Control can't create object | sampritiagarwal | Excel Programming | 0 | 08-03-2021 09:25 PM |
VBA to create a button to attach the active word doc to an email as a PDF without using Outlook | TAKMalcolm | Word VBA | 1 | 09-21-2017 01:52 AM |
![]() |
Katherine1995 | Word VBA | 6 | 11-17-2016 12:04 PM |
![]() |
zlodeh | Excel Programming | 1 | 02-24-2016 01:58 AM |
![]() |
Doug Needham | Excel Programming | 4 | 01-12-2015 10:54 PM |