vba outlook notepad excel

  1. H

    using VBA to edit subject line

    Hello all and many thanks for all past help! After searching, I believe I have found what I need to remove a phrase in emails, but when I run the code, I get the error and this is what I see when debugging. Here is my code: Sub Remove_OTP() Dim arr As Variant, i As Long arr = Array("This...
  2. N

    Paste content to Excel when .txt file (attachment) is opened

    Hi Guys, I have a lot of emails with txt attachments that I need to handle every day. I select the message, open the attachement in notepad (without saving) and then manually paste it to excel workbook. I want to be able when I open the attachment that it is automatically loaded in this excel...