title: Activating specific email in Outlook with VBA & deleting signature from the copied text
body: <p>I'm looking to use the <code>get</code> function in vba in order to activate a specific email in Outlook and then copy the body into a new email and send. I can use the <code>getlast</code> function to get the latest email in the inbox, however I would like to refine the code some more by selecting the latest email from a specific email address. </p>
  
  <p>Also, I'd love how to know how to delete the signature from the text pasted into the new email. </p>
  
  <pre><code>Sub Negotiations()
  
  Dim objMsg As Outlook.MailItem
  Dim objItem As Outlook.MailItem
  Dim BodyText As Object
  Dim myinspector As Outlook.Inspector
  Dim myItem As Outlook.MailItem
  Dim NewMail As MailItem, oInspector As Inspector
  
  Set myItem = Application.Session.GetDefaultFolder(olFolderInbox).Items.GetLast
  myItem.Display
  
  'copy body of current item
  
  Set activeMailMessage = ActiveInspector.CurrentItem
  activeMailMessage.GetInspector().WordEditor.Range.FormattedText.Copy
  
  ' Create the message.
  Set objMsg = Application.CreateItem(olMailItem)
  
  'paste body into new email
  Set BodyText = objMsg.GetInspector.WordEditor.Range
  BodyText.Paste
  
  'set up and send notification email
  With objMsg
      .To = "@gmail.com"
      .Subject = "Negotiations"
      .HTMLBody = activeMailMessage.HTMLBody
      .Display
  
  End With
  End Sub
  </code></pre>
  
  <p>any help would be appreciated, thank you guys!</p>