Help request to add a colored border to the message

Hi friends,

I want to add a colored border to the message. Please suggest me a code to achieve this target.

Any help will be highly appreciated.

Thanking you,

Hi, mso3,

what kind of message are you talking about? A couple of cells in a sheet, UserForm or the standard message box (where according to my knowledge you would have to make your own UF looking like a MsgBox in order to make a border)?

Ciao,
Holger

Hi Holger,

Greetings from me!

I’m sending the birthday wishing mails. Now to make the message more decent I want to add a red color border to the message.

Here I’m attaching a workbook for your perusal.

Thanking you,

Hio, mso3,

you coukd have passed a top that itīs Outlook and HTML you are tralking about. Not so surprising thereīs a border-element in HTML as well as VBA and you should have to integrate width, style and colour for it.

Code may look like

PHP Code: 

..."p style=""border:5px solid #FD0606;""... 


right after an opening tag and before center for the whole message as well as the closing tag at the end of the message. Code may not presented here in total due to security blocking (and I donīt have a version of outlook on hand at home to test)

I strongly recommend to use objects instead of repeating the sheetname over and over again, and a loop would reduce the number of lines in the code.

Ciao,
Holger

Hi, mso3,

as any HTML-code is blocked I may only offer the workbook without testing.

I donīknow why everybody uses a version of the code which is way beyond being effective as you could use the Autofilter with the newly entered formula on sheet "Data" and loop only on visible cells (if any).

Ciao,
Holger

Hi Holger,

Greetings from me!

I think it's not possible. So I'm marking the thread solved now. However, I learned a new approach from you to shorten the code.

I'm thankful to you for your continuous kind cooperation to solve problems.

Have a nice time.