Hi All,
I would like to edit this vba to a specific text and size in the html body. Text will be calibri and size will be 11. Can i get advice on where i can add in the code to enable this.
Please Login or Register to view this content.
Hi All,
I would like to edit this vba to a specific text and size in the html body. Text will be calibri and size will be 11. Can i get advice on where i can add in the code to enable this.
Please Login or Register to view this content.
Hello Michael35,
This is the basic idea. Rendering by the browser uses different sizing methods than the Excel worksheet so there is not a one to one correspondence. The browser will generally uses pixels but these are not the same as the pixels used by Excel. It is complicated and I am not going to attempt to explain it in this post. All text within the DIV element will be Calibri, if the computer receiving the email has it. The size is set to 100% of normal. If you need it to be bigger change the 100% to something larger. Be sure to check it before you send it out.
Your HTMLBody code is missing the opening tag for TABLE. You should make the change before you run this. Since I don't know where you have added the HTML and BODY tags in the HTMLBody code, I cannot guarantee the snippet will work because it is outside of where it is normally located.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks