Solved: Change email body text to HTML

[DLancy]

I am a DBA/Programmer and I am creating a template maker for the developers to submit db changes to me via Outlook using a custom form and vba. I can create the template, but I want to either (or possibly both) bold the key words or italicize the spots they need to replace. Also changing the comment lines to another color would be nice. I know HTML, so if I could force them to use HTML to create the message, that would work. Otherwise I'll need to know if they're using RTF or HTML and be able to make those changes with RTF. Thanks for the help.

- Doug

======= CODE SNIPPET ========

[vba]Sub InsertButton_click()
'Add SQL Template for an Insert Clause
TableName = UCase(InputBox("Table Name?", "INSERT", lastTable))
DRNumber = InputBox("DR Number? (Leave Blank for none.)", "INSERT", lastDR)
BodyText = InsertHeader(TableName, DRNumber)
BodyText = BodyText + "INSERT INTO " + TableName + " ( ColumnNames ) VALUES ( Values );" + vbNewLine
BodyText = BodyText + vbNewLine + "/*---------------------------------------------------------------*/" + vbNewLine + vbNewLine
Item.Body = Item.Body + BodyText
End Sub
[/vba]