![使用宏通过电子邮件发送文档并抄送其他用户](https://linux22.com/image/1423335/%E4%BD%BF%E7%94%A8%E5%AE%8F%E9%80%9A%E8%BF%87%E7%94%B5%E5%AD%90%E9%82%AE%E4%BB%B6%E5%8F%91%E9%80%81%E6%96%87%E6%A1%A3%E5%B9%B6%E6%8A%84%E9%80%81%E5%85%B6%E4%BB%96%E7%94%A8%E6%88%B7.png)
答案1
xlDialogueSendMail 不支持抄送地址。您可能需要切换到 Outlook 库或任何支持您的电子邮件客户端的库。
VBA 用于快速而简单的 Outlook 电子邮件:
Sub sendOutlookEmail()
Dim outlook As Object
Dim outlookMail As Object
Set outlook = CreateObject("Outlook.Application")
Set outlookMail = outlook.CreateItem(0)
With outlookMail
.To = "[email protected]"
.CC = "[email protected]"
.BCC = "[email protected]"
.Subject = "A Subject"
.Body = "A body"
.Attachments.Add ThisWorkbook.FullName
.Display
End With
End Sub