title: How to assign multiple listbox values to one variable and put those in Email "TO" field
body: <p>I am trying to be able to select multiple values in two listboxes and assign to two separate variables. I want to then take those variables containing the selections and generate an email with the variable contents populating the "TO" field in an outlook email. Right now I am getting a Run-Time Error 94 - Invalid Use of Null.</p>
  
  <p>Thanks for all your help!</p>
  
  <pre><code>Dim EAddress, MAddress As String
  
  Public Sub UserForm_Initialize()
  
  Emailfrm.EmpEmaillb.RowSource = "Searched_Employee_Email"
  Emailfrm.ManagerEmaillb.RowSource = "Searched_Manager_Email"
  
  End Sub
  
  Public Sub Email_Click()
  Dim OLobjMsg, NewMsg As Object
  
      EAddress = Emailfrm.EmpEmaillb.Value
      MAddress = Emailfrm.ManagerEmaillb.Value
  
      Set objMsg = CreateObject("Outlook.Application")
      objMsg.Session.Logon
      Set NewMsg = objMsg.CreateItem(0)
  
      With NewMsg
          .To = EAddress &amp; MAddress
          .Subject = "BT Employee Database Inquiry Email"
          '.Body = "Have a great weekend!"
      End With
  
      Unload Me
  
      NewMsg.Display
  End Sub
  </code></pre>