我有一个 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 = "<FONT SIZE = 3>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."
With OutMail
.SentOnBehalfOfName = ""
.To = sTo
.CC = sCC
.BCC = ""
.Subject = "Data Morning Alias Process - COMPLETE"
.HTMLBody = strbody & signature
.Display
End With
End Sub
我知道这部分代码:
strbody = "<FONT SIZE = 3.5>Good Morning;<p>We have completed our main aliasing
是与电子邮件正文文本大小相关的部分。但设置为 3 太小,设置为 4 又太大。所以我只是想知道是否有某种方法可以将字体设置为恰好大小 11,并将文本格式设置为 Calibri?
谢谢你!
我做了一些研究并能够编写这段代码:
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>"
显然通过设置"font-size=11pt"
而不是设置字体大小<font size=5>
,
它允许您像通常在文本编辑器中一样选择特定的字体大小,而不是像我的代码最初那样选择 1-7 之间的值。
This link http://www.w3schools.com/tags/tag_font.asp来自 simple MAN 的人给了我一些很好的信息。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)