title: How to automatically save an attachment, with overwrite?
body: <p>I'm trying to extract an Excel report from an Outlook email, and save it in a folder called "OLAttachments" in my Documents folder. </p>
  
  <p>I also need it to overwrite the previous day's file. These email attachments have the same name each day. </p>
  
  <p>This is what I have so far. Each time the email comes through, it saves a new file, whereas I would like to overwrite the existing file.</p>
  
  <pre><code>Public Sub SaveAttachmentsToDisk(MItem As Outlook.MailItem)
  Dim oAttachment As Outlook.Attachment
  Dim sSaveFolder As String
  sSaveFolder = "C:\Users\fmustapha\Documents\Outlook Attachments"
  For Each oAttachment In MItem.Attachments
      oAttachment.SaveAsFile sSaveFolder &amp; oAttachment.DisplayName
  Next
  End Sub
  </code></pre>