Using CSS with .HTMLBody/olFormatHTML in Excel Generated Emails

Question

I currently have a spreadsheet that I use to generate mass e-mails that I can format using HTML and it works really well. One thing that I have not been able to figure out is whether or not there is a way to also incorporate CSS styling within an HTML e-mail created through excel.

Has anyone tried this/had success with this before?

My current subroutine uses the Outlook Application to construct material into an HTML email. The code for calling/constructing is:

Sub Test_Email(what_address As String, subject_line As String, mail_body_message As String)
Dim olApp As Outlook.Application
Dim oAttatch As Outlook.Attachment

Set olApp = CreateObject("Outlook.Application")

Dim olMail As Outlook.MailItem

Set olMail = olApp.CreateItem(olMailItem)

With olMail

.To = what_address

.Subject = "My Subject"

.BodyFormat = olFormatHTML

.HTMLBody = mail_body_message
'mail_body_message is all text that resides in Cell A1 and it consists of body text of the email as well as the HTML tags that I use to organize the message display
.Display
End With
End Sub

Within cell A1, I have all of my message information. Starts with and ends with <HTML> </HTML> and then my message body resides within the tags. So far, when I have tried to insert CSS styles within the existing HTML in cell A1, it spits out the HTML just fine but treats the CSS as text.

You will need to add details describing exactly how you currently create these emails... — Tim Williams
– Tim Williams, Commented Sep 21, 2015 at 17:44

NickyTheWrench · Accepted Answer · 2015-09-21 18:21:03Z

1

You'll need to use inline CSS.

For example:

<img src="http://example.com/foo.jpg" style="max-width:100px;">

Or

<a href="http://example.com" style="color:#000;">

answered Sep 21, 2015 at 18:21

NickyTheWrench

3,2301 gold badge27 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user3794203 Over a year ago

Currently, when I use the inline HTML for inserting a button, this method does not appear to be functioning. Any thought on how this can be accomplished?

NickyTheWrench Over a year ago

So you are typing HTML directly within cell A1, and cell A1 is the body of the email? You included inline css within the HTML inside cell A1, however it is not working? Just trying to understand better.

user3794203 Over a year ago

Yes, correct. Using HTML I can alter the output of the message by changing things within cell A1 (using HTML tags) however, when I try to include inline CSS for an HTML button, this appears not to be supported. I was not sure if anyone else had ever attempted this and if there was some additional reference library that I would need to enable to support it.

Collectives™ on Stack Overflow

Using CSS with .HTMLBody/olFormatHTML in Excel Generated Emails

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related