At least you are amused... here is my code.
stText = "Ticket Status: " & varStatus & Chr$(13) & Chr$(13) & "Ticket Number: " & stTicketID & Chr$(13)
'stText = stText & "Received Date: " & RecDate & Chr$(13)
stText = stText & "Received Date: " & RecDate & Chr$(13) & "Assigned To: " & varName
'stText = stText & " Priority Level: " & " Case Type: " & Chr$(13)
'stText = stText & Chr$(13) & "Ticket Category: " & Chr$(13) & Chr$(13)
stText = stText & Chr$(13) & "User: " & varUserName & Chr$(13)
stText = stText & "Issue: " & Chr$(13) & Me.txt_Issue & Chr$(13) & Chr$(13)
'stText = stText & "This is an automated message, please do not respond to this email."
'Write the email content for sending to the asignee
DoCmd.SendObject , , acFormatTXT, varTo, varCC, , stSubject, stText, -1
I play with commenting things out... and randomly get the error "Reserved error" or "SendObject action has been cancelled". Is there some rule that I should know about for sending email from a form?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.