I'm aware of how to do mass emails from excel with vba. What's eluding me is how to retrieve cell values and combine with html code for formatting purposes. For example, I need to retrieve the text from E4 which is a date, into another cell which will have formatting html code, which will then be captured by vba. E4: Saturday, 23 December 2023 (generated as long date from 23/12/23) G27: = " Search (this isn't working as Excel is rejecting it) VBA strBody2 = ThisWorkbook.Sheets("CHRISTMAS INVITATIONS").Cells(27, 7).Text In OutMail .HTMLBody = strBody & strXmasPartyDate & strBody2 & strXmasLocation & strBody3 & strRSVP & .HTMLBody I need to do for date, email address and for general text as well. Yes, this has to be generated from Excel. I'm avoiding merging with Word.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel 2021 - mass email with vba - combine html code with cell values

Thread starter BrerRabbit
Start date Dec 5, 2023
Tags

combine html formatting code with cell values excel html with cell values vba

BrerRabbit

Board Regular

Dec 5, 2023

I'm aware of how to do mass emails from excel with vba. What's eluding me is how to retrieve cell values and combine with html code for formatting purposes. For example, I need to retrieve the text from E4 which is a date, into another cell which will have formatting html code, which will then be captured by vba.

E4: Saturday, 23 December 2023 (generated as long date from 23/12/23)
G27: = "<a href="""&E4&""><span style="text-align:center">Search</span></a> (this isn't working as Excel is rejecting it)

VBA
strBody2 = ThisWorkbook.Sheets("CHRISTMAS INVITATIONS").Cells(27, 7).Text

In OutMail
.HTMLBody = strBody & strXmasPartyDate & strBody2 & strXmasLocation & strBody3 & strRSVP & .HTMLBody

I need to do for date, email address and for general text as well. Yes, this has to be generated from Excel. I'm avoiding merging with Word.