Email VBA

DarrenF

Board Regular
Joined
Jun 9, 2014
Messages
64
Hello,

I'm using the below VBA to send an email through outlook and was hoping I can get some help on how to bold the body of the email. All I'm finding is how to bold a portion of the body. I would like to bold all of the body.

.To = Range("A82").Value
.CC = Range("A83").Value & "; " & Range("A84").Value
.BCC = Nothing
.Subject = "Support Report" & " " & Now()
.Body = Range("D82").Value
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

daverunt

Well-known Member
Joined
Jul 9, 2009
Messages
1,793
Office Version
2013
Platform
Windows
you need to use HTMLBody and html tags for making the text bold

HTML:
.HTMLBody = "<b>" & Range("D82").Value & "</b>"
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,099,006
Messages
5,465,965
Members
406,457
Latest member
Pinky Rose Jordan

This Week's Hot Topics

Top