title: Email 2 or more Excel Workbooks with Vba
body: <p>I cannot figure out how to send more than 1 workbook for the life of me!
  I know a couple different ways to email 1 workbook, I place them here.</p>
  
  <pre><code>Sub SendActiveWorkbook()
                  ActiveWorkbook.SendMail _
      Recipients:=Array("MyEmail@123.com", "AnotherEmail@123.com"), _
      Subject:="Write subject here"                 
  End Sub
  </code></pre>
  
  <p>And  </p>
  
  <pre><code>Sub RouteActiveWorkbook()   
      With ActiveWorkbook
             .HasRoutingSlip = True
                 With .RoutingSlip
                      .Delivery = xlAllAtOnce
                      .Recipients = Array("MyEmail@123.com", "AnotherEmail@123.com")
                      .Subject = "CSAM Lux BIEO and BCF breakdown"
                      .Message = "Attached are the breakdowns as of " &amp; Date
                 End With
              .Route
       End With
  End Sub
  </code></pre>
  
  <p>I seem to be only able to send 1 workbook in a given email. (it will not solve my problem to make my 2 workbooks into 1 workbook). Anyone had any success with sending more than 1 workbook in an email?</p>