title: Add attachment with varying date in file name to Outlook mail
body: <p>I have an Excel file named "Home Audio for Planning (28-3-2013).</p>
  
  <p>The date will change every day but the text will be the same.</p>
  
  <p>How do I attach those files to Outlook?</p>
  
  <pre><code>Sub Test()
  
      Dim OutApp As Object
      Dim OutMail As Object
      Set OutApp = CreateObject("Outlook.Application")
      Set OutMail = OutApp.CreateItem(0)
      With OutMail
          .To = ""
          .CC = ""
          .BCC = ""
          .Subject = "This is the Subject line"
          .Body = "Hello World!"
  
          .Attachments.Add ("C:\Users\Desktop\Today\Home Audio for Planning   (28-3-2013).xlsx")
  
          .Display
      End With
      On Error GoTo 0
  
      Set OutMail = Nothing
      Set OutApp = Nothing
  
      With Application
          .ScreenUpdating = True
          .EnableEvents = True
      End With
  
  End Sub
  </code></pre>