I have a VBA script that that generates and email when a VBA button is pushed in a given worksheet. The script currently generates the email in a relatively small font. I was wondering if there is a way to set the font to Calibri, and the text sive to exactly 11. I did a little research and was able to write this code: strbody = 'Good Morning;We have completed our main aliasing process for today. All assigned firms are complete. Please feel free to respond with any questions.Thank you.'
Apparently by setting the 'font-size=11pt' instead of setting the font size, It allows you to select a specific font size like you normally would in a text editor, as opposed to selecting a value from 1-7 like my code was originally. This from simpLE MAn gave me some good info. Set texts with different sizes and styles, and size and style for texts from cells ( with Range) Sub EmailManuellAbsenden Dim ghApp As Object Dim ghOldBody As String Dim ghNewBody As String Set ghApp = CreateObject('Outlook.Application') With ghApp.CreateItem(0).To = Range('B2').CC = Range('B3').Subject = Range('B4').GetInspector.Display ghOldBody =.htmlBody ghNewBody = ' & 'Arial Text 14' & Range('B5') & ' & Range('B6') & ' & 'Ciller 21' & Range('B5').htmlBody = ghNewBody & ghOldBody End With End Sub 'Fill B2 to B6 with some letters for testing ' = works for all Range Objekts.
By default, Excel 2016 for Mac uses Body Font in font size 12, which is displayed as Calibri font in font size 12 when you type data in a worksheet, header or footer, or text box. However, you can change the default font and font size for all new workbooks that you create. Excel worksheets can store a lot of data, which can make it hard to read individual cells. If you find the text in a cell is too small, you can increase its font size and adjust the row height.