title: Send Email To Recipient List Excel
body: <p>I want to send an automatically from Excel as it is running reports, but I need it to do a VLOOKUP on the client name and select all email addresses that are assigned to that client. Can you help please?</p>
  
  <p>So I will have a table such as below, on a sheet named <code>Client Emails</code></p>
  
  <pre><code> Company 1 | example@mail.com
   Company 1 | example2@mail.com
   Company 2 | somebody@somewhere.com
   Company 3 | you@here.com
   Company 1 | him@there.com
  </code></pre>
  
  <p>to make it easier to keep up to date. Right now I have the below code which sends the email correctly, but I would like it to pull the addresses from workbook and not the code as it is easier to update this way.</p>
  
  <pre><code> Set OutApp = CreateObject("Outlook.Application")
   Set OutMail = OutApp.CreateItem(0)
   With OutMail
      .To = "example@mail.com; example2@mail.com"
      .CC = ""
      .BCC = ""
      .Subject = "Subject"
      .Body = "Hello World."
      .Attachments.Add ("Attachment")
      '.Display
      .Send
   End With
   On Error GoTo 0
   Set OutMail = Nothing
   Set OutApp = Nothing
  </code></pre>