Sending emails from excel

[Undz12]

Hi

I'm a beginner and I've been playing around with sending emails from excel

I'm currently composing the body of the email by just referencing text in a cell in excel
But I'd like some of the text to come out as bold mid sentence, and ideally I'd like this text to be taken from a cell in Excel (so I can easily update the part mid sentence that I want bold)

What is the best solution to this problem please?

 

[Trevor G]

You would look to use HTMLBody to have the formatting within the body of your email. Have you started any VBA to generate the email yet?

 

[Undz12]

Hi Trevor, thank you for your reply please see below:
The goal is to construct a sentence using 3 cells in excel with one of the cells coming out in bold:

'Essential Code
Dim OutApp As Object
Dim OutMail As Object
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)

' Email Body
With OutMail
.HTMLBody = Range("A1").Value & Range("A2").Value & Range("A3").Value
.Display
End With

'Clean Up Code
Set OutMail = Nothing
Set OutApp = Nothing

 

[lrobbo314]

You're adding text to the .HTMLBody part of the email.

So, since it's html, the way that you would style it to be bold would be to add html bold tags around the text you want bolded.

If I understand correctly, that you want Range("A2").Value to be bolded, you would do something like this.

.HTMLBody = Range("A1").Value & "<b>" & Range("A2").Value & "</b>" & Range("A3").Value

 

[Trevor G]

To help understand the HTML tags I would recommend you taking a look at W3School as a website. The link to the website is shown below:

W3Schools Online Web Tutorials

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com

 

[Undz12]

That's great thank you so much for your help I did it