![]() |
|
|||||||
|
|
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 |
|
|
Similar Threads
|
||||
| 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 |
Run-time error '-2147467259 (80004005)': Method 'Insert' of object 'BuildingBlock' failed
|
Katherine1995 | Word VBA | 6 | 11-17-2016 12:04 PM |
Run-time error '424': Object required
|
zlodeh | Excel Programming | 1 | 02-24-2016 01:58 AM |
Run Time Error 424 - Object Required
|
Doug Needham | Excel Programming | 4 | 01-12-2015 10:54 PM |