title: How can I ignore an email attachment if missing from folder
body: <p>I have 2 things I need amending</p>
  
  <p>I currently have code that pulls from column A the email address and attaches 3 files which are identified in columns B C and D. However the files in column D are not always present, and I would like the code to ignore them if not found. </p>
  
  <p>Also, can the email include the users standard signature?</p>
  
  <pre><code>Sub email1()
  
  Dim OutLookApp As Object
  Dim OutLookMailItem As Object
  Dim lastRow As Long
  Dim MailDest As String
  Dim subj As String
  
  lastRow = ThisWorkbook.Worksheets("sheet1").Cells(Rows.Count, "A").End(xlUp).Row 'change worksheet
  
  
  If fileExists("g:\test\", Cells(i, 2).Value &amp; ".xls") Then
  For i = 2 To lastRow
  
  Set OutLookApp = CreateObject("Outlook.application")
  Set OutLookMailItem = OutLookApp.CreateItem(0)
  Set Attach = OutLookMailItem.Attachments
  
  With OutLookMailItem
  .SentOnBehalfOfName = " test@test.co.uk "
      .To = Cells(i, 1).Value
      '.cc = "test@test.co.uk"
      .Subject = Cells(i, 6).Value
      .Body = Cells(i, 7).Value
   Attach.Add " g:\test\", \" &amp; Cells(i, 2).Value &amp; ".xls"
              .Display 'for debugging
      SendKeys "^{ENTER}"
    End If
  End With
  SendKeys "^{ENTER}"
  Next
  MsgBox ("Emails have all been Sent Successfully")
  End Sub
  </code></pre>