title: Excel VBA Creating Outlook Email- Adding multiple not working
body: <pre><code> With myMail
      .Display
      .Attachments.Add &quot;C:\DRR Report\&quot; &amp; savedate &amp; &quot; - Approved DRR Detail.xlsx&quot;
      .Attachments.Add &quot;C:\DRR Report\&quot; &amp; savedate &amp; &quot; - Non Approved DRR Detail.xlsx&quot;
      .To = varEmail
      .Subject = &quot;Weekly DRR Reports&quot;
      .Body = &quot;Attached is this week's DRR report.&quot;
  End With
  </code></pre>
  <p>This snippet of code, in Excel, properly opens Outlook and does everything except add the 2nd attachment file.</p>
  <p>It does not matter which of the two <code>.Attachments.Add</code> files comes first, it only adds the one that is executed first, leaving the 2nd file out (so it's not a name/path issue).</p>
  <p>Any ideas why it will only execute 1 <code>.Attachments.Add</code> and skip the 2nd?</p>