使用Excel在自动电子邮件中发送多个附件

我希望有人可以提供帮助。

我有一个宏观的宏观，可以看着一列电子邮件地址，并将单独的电子邮件发送给带有指定附件的地址。宏的运作良好，但是我不确定如何使宏中的宏以同一电子邮件发送两个附件。

请帮忙。完整的代码为

Sub Send()
'Working in Excel 2000-2016
Dim OutApp As Object
Dim OutMail As Object
Dim sh As Worksheet
Dim cell As Range
Dim FileCell As Range
Dim rng As Range
With Application
    .EnableEvents = False
    .ScreenUpdating = False
End With
Set sh = Sheets("Email")
Set OutApp = CreateObject("Outlook.Application")
For Each cell In sh.Columns("B").Cells.SpecialCells(xlCellTypeConstants)
    'Enter the path/file names in the C:Z column in each row
    Set rng = sh.Cells(cell.Row, 1).Range("C1:Z1")
    If cell.Value Like "?*@?*.?*" And _
       Application.WorksheetFunction.CountA(rng) > 0 Then
        Set OutMail = OutApp.CreateItem(0)
        With OutMail
            .To = cell.Value
            .Subject = cell.Offset(0, 7).Value
            .HTMLBody = "<html><body><p>Hello " & cell.Offset(0, -1).Value & "<p></p>" _
            & cell.Offset(0, 2).Value & "</p><p>" _
            & cell.Offset(0, 3).Value _
            & Signature & "</body></html>"
            For Each FileCell In rng.SpecialCells(xlCellTypeConstants)
                If Trim(FileCell) <> "" Then
                    If Dir(FileCell.Value) <> "" Then
                        .Attachments.Add FileCell.Value
                    End If
                End If
            Next FileCell
            .Send
            '.Display
        End With
        Set OutMail = Nothing
    End If
Next cell
Set OutApp = Nothing
With Application
    .EnableEvents = True
    .ScreenUpdating = True
End With
End Sub

您可以运行

.Attachments.Add FileCell.Value

用不同的附件路径两次线

相关内容

最新更新

热门标签：