Email without object

eholtman

Registered User.
Local time
Yesterday, 22:04
Joined
Oct 12, 2004
Messages
54
Is it possible to create a automatic email to not have a object to send. I am using Docmd.SendObject is there a command that if you only want to send To; Subject; and MessageText

Current code

Dim stDocName As String


stDocName = "xxx"

DoCmd.SendObject objecttype:=acSendReport, _
ObjectName:=stDocName, outputformat:=acFormatSNP, _
To:=Me.Technican, subject:="Update for Circuit " & Me.Primary_ID & ", Located at " & Me.Cust_Acro & " " & Me.Cust_Address, MessageText:="Updated status of circuit" & vbCrLf & "Technican:" & Me.Technican & vbCrLf & " Received Request: " & Me.Received_Date & vbCrLf & " Order Requested: " & Me.Order_Date & vbCrLf & " Installation of circuit: " & Me.Installed_Date & vbCrLf & " Data Communication equipment installed: " & Me.Completed_Date

Exit_Email_Click:


So as you can see I am pulling data from my fields. All I want to do is have the To; Subject; and MessageText with no Object file.
 
Use acSendNoObject instead of acSendReport.
 
Thanks works great. Great to know the secert words.
 
The secret word is "Help", since VBA Help on SendObject contains info on this.
 

Users who are viewing this thread

Back
Top Bottom