vba - List the filenames of attachments - Stack Overflow

PHOTO EMBED

Fri Feb 07 2025 05:38:23 GMT+0000 (Coordinated Universal Time)

Saved by @acassell

Private Sub CommandButton2_Click()

Dim a As Attachments
Dim myitem As Folder
Dim myitem1 As MailItem
Dim j As Long
Dim i As Integer

Set myitem = Session.GetDefaultFolder(olFolderDrafts)

For i = 1 To myitem.Items.Count
  If myitem.Items(i) = test1 Then
    Set myitem1 = myitem.Items(i)
    Set a = myitem1.Attachments

    MsgBox a.Count

    ' added this code
    For j = 1 To myitem1.Attachments.Count
      MsgBox myitem1.Attachments.Item(i).DisplayName ' or .Filename
    Next j

  End If
Next i
End Sub
content_copyCOPY

https://stackoverflow.com/questions/11809782/list-the-filenames-of-attachments