format userform output to email

**EagleInsight** · 01-22-2014, 09:02 PM

I have a macro that creates an email based on the values inputted by users in both listboxes and textboxes on a userform. However I want to make the values a certain format, e.g. some text red and other text bold.

what code would i add to enable this?

e.g.
With MyItem
.To = "xxx@xxx.com
.Subject = ListBox7.Value
.Body = ListBox1.Value & vbNewLine & _ <----- want to make this listbox value red
TextBox1.Value & vbNewLine & _ <--- want to make this textbox value bold
"Enjoy your day " <--- want to make this plain text value bold
.display

Gracias!

**event21** · 01-22-2014, 09:28 PM

Hi -

Everytime you posted a codes, please have it enclosed in tags

.HTMLBody = "<html><font color=red>" & ListBox1.Value & "</font><br>" & _
"<b>" & TextBox1.Value & "</b><br>" & _
"<b>Enjoy your day </b></html>"
.display

event

format userform output to email

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

format userform output to email

Re: format userform output to email

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Email output variable

Email text in a cell - maintaining font format, spacing, line breaks in email body

Wrong Date Format in output userform

Compare two email lists and output non-matching

userform output to procedure

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions