|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
转发邮件, 并在 原邮件基础上增加文字, 再发出。
- Sub 转发邮件()
- '//选中的邮件全部转发
- 'On Error Resume Next
- Dim myOlApp As New Outlook.Application
- Dim myOlExp As Outlook.Explorer
- Dim myOlSel As Outlook.Selection
- Dim myItem As Outlook.MailItem
- Dim myForwardItem As Outlook.MailItem
- Dim x As Integer
- Set myOlExp = myOlApp.ActiveExplorer
- Set myOlSel = myOlExp.Selection
- For x = 1 To myOlSel.Count
- If (myOlSel.Item(x).Class = 43) Then
- Set myItem = myOlSel.Item(x)
- Set myForwardItem = myItem.Forward
- With myForwardItem
- .Recipients.Add "123456789@qq.com"
- .CC = "111111111@qq.com"
- .HTMLBody = "<Font Face=微软雅黑 size=3>" & "Dear xxx,<BR><BR>Replied, Please go on.<BR>" & _
- .HTMLBody
- .Display
- End With
- End If
- Next x
- End Sub
复制代码
|
|