G
Greg
I have the following function
Private Sub SendEmail_Click()
Dim strSubject As String
Dim strEmailList As String
Dim strMessage As String
Dim strMessage2 As String
On Error GoTo Err_SendEmail_Click
strSubject = "Please investigate" & " " & [Ticket #]
strEmailList = "(e-mail address removed) "
strMessage = Me.Text_Description
strMessage2 = "Assign to:"
DoCmd.SendObject acSendNoObject, , acFormatRTF, strEmailList, , ,
strSubject, strMessage, strMessage2
Exit_SendEmail_Click:
Exit Sub
Err_SendEmail_Click:
MsgBox Err.Description
Resume Exit_SendEmail_Click
End Sub
First -- I am getting error message: An expression you entered is wrong data
type for one of the arguments. How do I fix that?
Is it possible to:
place srtMessage2 in a line below strMessage?
Can I set different font and size in body of my email by adding code to this
function? For example can I make body of my email bold for exp?
Thanks a lot
Private Sub SendEmail_Click()
Dim strSubject As String
Dim strEmailList As String
Dim strMessage As String
Dim strMessage2 As String
On Error GoTo Err_SendEmail_Click
strSubject = "Please investigate" & " " & [Ticket #]
strEmailList = "(e-mail address removed) "
strMessage = Me.Text_Description
strMessage2 = "Assign to:"
DoCmd.SendObject acSendNoObject, , acFormatRTF, strEmailList, , ,
strSubject, strMessage, strMessage2
Exit_SendEmail_Click:
Exit Sub
Err_SendEmail_Click:
MsgBox Err.Description
Resume Exit_SendEmail_Click
End Sub
First -- I am getting error message: An expression you entered is wrong data
type for one of the arguments. How do I fix that?
Is it possible to:
place srtMessage2 in a line below strMessage?
Can I set different font and size in body of my email by adding code to this
function? For example can I make body of my email bold for exp?
Thanks a lot