Скачать или смотреть How to Change Font Color in HTML Using VBA in Excel

Struggling to change font color in HTML emails using VBA in Excel? This guide explains how to correctly format your email body to apply color changes without issues.
---
This video is based on the question https://stackoverflow.com/q/74693761/ asked by the user 'Jena Alissa' ( https://stackoverflow.com/u/10402142/ ) and on the answer https://stackoverflow.com/a/74694428/ provided by the user 'Guillaume BEDOYA' ( https://stackoverflow.com/u/20522241/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Change font color in html VBA Excel

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Change Font Color in HTML Using VBA in Excel

Creating dynamic emails through VBA in Excel can seem daunting at first, especially when it comes to formatting elements like font color. Many users find themselves frustrated trying to properly format their email body, only to discover that the HTML tags display as text instead of rendering their designed styles. In this guide, we're going to tackle the specific challenge of changing the font color of text in an HTML email created using VBA.

The Problem: Changing Font Color in an HTML Email

Imagine you are coding an email that displays essential information. You want to emphasize certain sections, for example, changing the text color of "Site" to red. However, when you attempt to include HTML styling in your string, the tags simply show up as plain text in the email, which is not the intended outcome.

Here’s a direct example of the issue:

[[See Video to Reveal this Text or Code Snippet]]

In this code, if you use the .Body attribute to send your email, the HTML styling will not be rendered, leading to frustrated users who see the tags instead of the colored text.

The Solution: Using HTMLBody in VBA

To successfully apply HTML formatting and change the font color, you must use the .HTMLBody property of your Outlook mail item instead of the .Body property. Here’s how you can do it step by step.

Step-by-Step Guide

Declare Your Outlook Mail Item:
Ensure that you have defined your mail item at the beginning of your VBA script.

[[See Video to Reveal this Text or Code Snippet]]

Constructing the Email Body:
Following the previous loop structure but modifying it to use the .HTMLBody, it should look like this:

[[See Video to Reveal this Text or Code Snippet]]

Final Thoughts

When creating HTML emails through VBA in Excel, remember the critical role of using the .HTMLBody property for content that includes HTML tags. This will ensure that your formatting is applied correctly, allowing you to emphasize parts of your message, such as changing text color.

By following the steps outlined above, your emails will appear professionally formatted and visually appealing.

Happy coding!