title: mailitem.entryID in Excel VBA
body: <p>Can I use mailitem.entryID in Excel VBA?</p>
  
  <p>I have a tool using excel where I can send an outlook email to recipients using spreadsheet as the UI to display user data. I need to store the entryID of each of the emails send to the user in the excel table. Can I set in the code (excel vba) <code>mailitem.entryID = worksheet.cells().value</code> ? Will it retrieve the entryID? Can you give me your input regarding this? Thank you for your help. </p>
  
  <hr>
  
  <pre><code>Dim AppOutlook As Object
  Dim MailOutlook As Object
  Dim Emailto, ccto, sendfrom As String
  
  Set AppOutlook = CreateObject("Outlook.Application")
  Set MailOutlook =AppOutlook.CreateItem(0)
  Emailto = worksheet.Cells().Value
  ccto = worksheet.Cells().Value
  sendfrom = "email"
  
    With OutMail
      .SentOnBehalfOfName = sendfrom
      .To = Emailto
      .CC = ccto
      .BCC = ""
      .Subject = 
      .BodyFormat = olFormatHTML
      .HTMLBody = "body here"
      .Send 
  </code></pre>
  
  <p>This is my code, and I plan to add the code worksheet.cells.value = MailOutlook.entryID at the last line of the code. Is it possible? and where to add the AddItem event?</p>