Change HTML email body font type and size in VBA

by

I did a little research and was able to write this code:

strbody = "<BODY style=font-size:11pt;font-family:Calibri>Good Morning;<p>We have completed our main aliasing process for today.  All assigned firms are complete.  Please feel free to respond with any questions.<p>Thank you.</BODY>"

apparently by setting the "font-size=11pt" instead of setting the font size <font size=5>,
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 link from simpLE MAn gave me some good info.

More Related Contents:

  1. How to copy Outlook mail message into excel using VBA or Macros
  2. Copy Excel range as Picture to Outlook
  3. Paste Excel range in Outlook
  4. Update excel sheet based on outlook mail [closed]
  5. Sending mail using Outlook where the Send method fails
  6. Email a single attachment from folder of files each to a different person
  7. How to send mail when the .Send does not work?
  8. How to add an attachment to an email using VBA in Excel
  9. How to send email to multiple recipients with addresses stored in Excel?
  10. Type Mismatch in Loop to scan Outlook Messages [duplicate]
  11. Finding a workbook in one of multiple Excel instances
  12. Convert Early Binding VBA to Late Binding VBA : Excel to Outlook Contacts
  13. How to Send Email When Computer is Locked?
  14. How to add a named sheet at the end of all Excel sheets?
  15. Delete Row based on Search Key VBA
  16. How to add a button programmatically in VBA next to some sheet cell data?
  17. How can I kill task manager processes through VBA code?
  18. How do I click a link on a web page using Excel VBA?
  19. Ping IP Address with VBA code and return results in Excel
  20. VBA copy cells value and format
  21. Paste Excel Chart into Powerpoint using VBA
  22. running excel macro from another workbook
  23. Multiply Entire Range By Value?
  24. EXCEL VBA UserInterfaceOnly:= True not working
  25. VBA Excel – IFERROR & VLOOKUP error
  26. Embedding image in email with VBA
  27. How can I loop through a subset of worksheets?
  28. VBA Excel simple Error Handling
  29. How to do a “Save As” in vba code, saving my current Excel workbook with datestamp?
  30. How to save semi-colon delimited csv file using VBA?

Leave a Comment