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?