Alter existing VBA code for font and font size

**PitchNinja** · 06-23-2022, 02:29 PM

Hello, I found a code that will allow me to export a selection that I highlight in excel to the body of an email. It works great but I was wondering how I might have outlook keep the font consistent. In the excel file, the font is Calibri size 11 so that's what I'd also like the rest of the added text in the email body to be. The code is:

Please Login or Register  to view this content.

So the part where i have:

.HTMLBody = "Updated attendance through " & CDate(Date - 1) & RangetoHTML(rng)

Currently that is coming up as Times New Roman size 12. Can this code somehow incorporate having Calibri 11 for that line?

Also, is it also possible to have my Outlook signature appear after it pastes the table? This composes an email without my signature. Thanks in advance for any help!

**TMS** · 06-23-2022, 03:33 PM

To change the font and size, you would need to use <font> tag.

See: https://www.w3schools.com/HTML/tryit...e=tryhtml_font

As for the signature, see: https://www.rondebruin.nl/win/s1/outlook/signature.htm

**PitchNinja** · 06-24-2022, 09:47 AM

Sorry but I'm really struggling here. I only have the most basic understanding of VBA and really just Google what codes I need and then paste them into the excel files. When it comes to altering them, I really don't know what I'm doing. I took a stab at it and of course it's not working but the best I could come up with was what I made in Bold underline:

Please Login or Register  to view this content.

I can get the signature to attach in the email now with this, but the signature normally has an image in it but that is not displaying in the email with this altered code. This was my wild guess. Am I even somewhat close? The font issue I'm still unsure on how to do.