Creating Bold Text in email with VBA code

**Bobbbo** · 11-18-2022, 04:14 PM

My program sends an email at the ends. Currently the email is just is default text. What I want to do is have the VBA code make one of the paragraphs in the body of the email be displayed in another color as well as being "bold" font. I have been led to believe I need to change the Body of the email to mtml code, but I am not sure. Here is the current piece of code:

Please Login or Register  to view this content.

All the paragraph's text in the email body are pulled from a spreadsheet with the Excel workbook. This is the paragraph I want to change to another color as well be in "bold" font but all the body could be in html in regular font:

Please Login or Register  to view this content.

Thanks in advance for any help you people can give me.

**6StringJazzer** · 11-18-2022, 10:29 PM

Yes, you have to use HTML to apply any kind of formatting.

Please Login or Register  to view this content.

Example shows red. Replace hex code with desired color.

Has not been tested.

**Bobbbo** · 11-19-2022, 01:28 PM

Thanks 6StringJazzer,

It worked perfectly. Thanks so much.

FYI if you add where the color is identified you will get the color with the text being BOLD.

Bob

Please Login or Register  to view this content.

**6StringJazzer** · 11-19-2022, 05:36 PM

Looks like I forgot about the bold. You can use ... for bold. If you use don't forget .

**Bobbbo** · 11-20-2022, 01:36 PM

You are right. If I forget the the remainder of the text in the email stayed Bold. This way on the paragraph that is red remains bold. Thnaks again!

**6StringJazzer** · 11-20-2022, 02:21 PM

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

**Bobbbo** · 11-20-2022, 04:06 PM

Done! Thanks Again

Creating Bold Text in email with VBA code

LinkBack

Thread Tools

Rate This Thread

Display

Creating Bold Text in email with VBA code

Re: Creating Bold Text in email with VBA code

Re: Creating Bold Text in email with VBA code

Re: Creating Bold Text in email with VBA code

Re: Creating Bold Text in email with VBA code

Re: Creating Bold Text in email with VBA code

Re: Creating Bold Text in email with VBA code

Thread Information

Users Browsing this Thread

Similar Threads

Bold Text in Body of Email

Assistance sending email with Lotus Notes through excel - Bold Text

[SOLVED] Text to Bold, sending to email/Outlook

[SOLVED] Email code. How to format specific lines in bold.

[SOLVED] Bold text on Access VBA code

Bold Text in Email body Lotus notes

Automatically outline all email addresses in a given text by putting them in red-bold

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions