Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBox value on an email body with same format
I have TextBox1 in Sheet1 and in that TextBox I have paragraph which
is formated like the tob line in that paragraph is in bold and in Black font colour and then remaining text lines are in blue font colour. I have macro (see one line of that macro below) which put that paragraph of TextBox1 in an email body ..Body = Sheets(1).TextBox1.Value The only problem is that when the TextBox1 paragraph appears on an email body it losses all the formats which are appear in TextBox and becoms simple paragrapgh like no colour etc. How can I keep the same format which is appear in TextBox1 paragraph on an email. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink in body of VBA email | Excel Discussion (Misc queries) | |||
COPY/PASTE to body of email the format of Excell cell | Excel Programming | |||
how do you email a portion of a worksheet (range) as an insert into the body of an email? | Excel Programming | |||
Email Workseet as Body of email | Excel Programming | |||
body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) |