Editing my email message 1

[jdwm2310]

Hi Guys,

I would like to know how I can insert paragraphs in my email message:

Private Sub Send_Click()
SendNotesMail "This ticket has been routed by the HR Help Desk", "", Me.Route_To, "Please contact the following employee: " & CallerName & " at : " & Telephone & ", after reviewing the following question: " & RequestedQuestion & " Thank you, " & UserName, True
DoCmd.Close acForm, "HelpDeskCalls", acSaveYes
DoCmd.OpenForm "TicketOption"
End Sub


i want it to look like the body text to look something like this:


The following individual contacted the HR HelpDesk, CallerName and Telephone.

Message Details : RequestedQuestion

Please contact as necessary.

Thank you,
HelpDeskCalls

 

[cyoung]

Use vbCrLf between the different elements of your message

emailtext = "The following individual contacted the HR HelpDesk " & callername & telephone & vbCrLf & "Message Details: " & RequestedQuestion & vbCrLf & "Please contact as necessary." & vbCrLf & "Thank you," & vbCrLf & "HelpDeskCalls"

Hope this helps!

 

[jdwm2310]

cyoung,

your posting was extremely helpful, i have one more question: how can I enter spacing between the paragraphs. It now looks like this

The following individual contacted the HR Help Desk: Molina, Ruth at : 383-3226
Message Details: Test
Please contact if necessary.
Thank you,
Administrator

but I want it to look like this:

The following individual contacted the HR Help Desk: Molina, Ruth at : 383-3226

Message Details: Test

Please contact if necessary.

Thank you,
Administrator

One more thing, could I make some words bold?

 

[cyoung]

Just add a vbCrLF where you want the line break to appear.

Since you are dealing with text only, there is not a way to make any of the words bold (at least that I am aware of)

Good Luck!

 

[jdwm2310]

cyoung,

thanks for everything!!!!!!!!! it works perfectly

 

[jdwm2310]

Is it possible if I can add color to the text?

 

[datatech7F]

Or use & chr(13)