在VBA中更改HTML电子邮件正文字体类型和大小

 job2672488 发布于 2023-01-19 19:21

我有一个VBA脚本,当在给定的工作表中按下VBA按钮时,该脚本会生成并发送电子邮件.

该脚本当前以相对较小的字体生成电子邮件.我想知道是否有一种方法可以将字体设置为Calibri,文本正好适用于11.

这是当前的VBA脚本:

Private Sub CommandButton1_Click()

Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Dim strUser As String
Dim signature As String
Dim sTo As String
Dim sCC As String
    'For To field
    Set emailRng = Worksheets("Send Email").Range("D3:I6")

    For Each cl In emailRng
        sTo = sTo & ";" & cl.Value
    Next

    sTo = Mid(sTo, 2)

    'For CC field
    Set emailRngCC = Worksheets("Send Email").Range("D8:I11")

    For Each cl In emailRngCC
        sCC = sCC & ";" & cl.Value
    Next

    sCC = Mid(sCC, 2)


Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
    With OutMail
    .Display
    End With
        signature = OutMail.HTMLBody


    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." With OutMail .SentOnBehalfOfName = "" .To = sTo .CC = sCC .BCC = "" .Subject = "Data Morning Alias Process - COMPLETE" .HTMLBody = strbody & signature .Display End With End Sub

我知道这部分代码:

strbody = "Good Morning;

We have completed our main aliasing

是与电子邮件正文文本大小相关的部分.但是3的设置是小的,4的设置太大.所以我只是想知道是否有某种方法我可以将字体设置为11格式,并将文本格式化为Calibri?

谢谢!

1 个回答
  • 我做了一点研究,并且能够编写这段代码:

    strbody = "<BODY 
    

    显然,通过设置"font-size=11pt"而不是设置字体大小<font size=5>,它允许您像在文本编辑器中一样选择特定的字体大小,而不是像我原来的代码那样选择1-7中的值.

    来自simpLE MAn的这个链接给了我一些很好的信息.

    2023-01-19 19:24 回答
撰写答案
今天,你开发时遇到什么问题呢?
立即提问
热门标签
PHP1.CN | 中国最专业的PHP中文社区 | PNG素材下载 | DevBox开发工具箱 | json解析格式化 |PHP资讯 | PHP教程 | 数据库技术 | 服务器技术 | 前端开发技术 | PHP框架 | 开发工具 | 在线工具
Copyright © 1998 - 2020 PHP1.CN. All Rights Reserved 京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有