Solved How do I make text underline in strbody (VBA)

September 15, 2016 at 11:11:05
Specs: Windows 7
I have a pretty long string in my strbody but shortened it for this question; can someone tell me how to underline "Monthly Projections:"?

strbody = "Monthly Projections:" & "<br />" 


See More: How do I make text underline in strbody (VBA)

Reply ↓  Report •


#1
September 15, 2016 at 11:33:04
If I am not mistaken, you are passing this as text to an email correct?

If that's the case, then I don't think you can do it. Even if you were keeping this within an Excel sheet and putting the text in a cell, you couldn't store the formatted text in the cell. You have to put the text in the cell and then apply the formatting via more VBA code. It's 2 completely separate operations.

Since you are passing this text to another application, I believe that the only think you'll get is the text and all formatting would have be done in the other app.

I could be wrong...feel free to do some web searches on the matter.,

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Reply ↓  Report •

#2
September 16, 2016 at 11:56:40
✔ Best Answer
Cant you just:
strbody = "<u>Monthly Projections:</u><br />"
?

How To Ask Questions The Smart Way


Reply ↓  Report •

#3
September 16, 2016 at 12:23:00

Reply ↓  Report •

Related Solutions

#4
October 3, 2016 at 05:44:09
Ravor2.3, that worked for me, I have been on vacation for 2 weeks sorry for the delayed response.

DerbyDad03 thank you for marking as best answer.

message edited by mecerrato


Reply ↓  Report •


Ask Question