Search results

  1. D

    VBA to edit body of incoming email and forwarding it

    yes its running. i deleted the middle part of the code where it extracts the table and it forwards emails A.O.K
  2. D

    VBA to edit body of incoming email and forwarding it

    Hi Diane, i thought i solved the issue..but for some reason it stopped working when i turned it on today. I don't think i made any changes...i went to tools>rules>made new rule>when receiving mail with subject ____ run script>run the following: Sub Modify_PSE(Item As Outlook.MailItem) Set...
  3. D

    VBA to edit body of incoming email and forwarding it

    Found a solution! May not be the most elegant: Sub Modify_PSE(Item As Outlook.MailItem) Set myForward = Item.Forward myForward.Subject = "new subject here" Dim lTblStart As Long, lTblEnd As Long Set myForward = ActiveInspector.CurrentItem.Forward lTblStart = InStr(1...
  4. D

    VBA to edit body of incoming email and forwarding it

    Hi Diane, The old word only found when it was just text. No hyperlink associated with it. My new idea is maybe Copy just the table (and its content) and forward it, or delete everything but the table (and its content) and forward it. Which is easier to do?
  5. D

    VBA to edit body of incoming email and forwarding it

    An idea that may work is if it were possible to delete all text items in the body except for items in a table. Is that tricky?
  6. D

    VBA to edit body of incoming email and forwarding it

    Hi Diane, thank you for your help. The code sortve works! In the testing phase, the word "website" got successfully replaced with "new website" but in actuality, because the word"website" was tied to a hyperlink so it didnt work as i intended. Also, is there no way to replace words while...
  7. D

    VBA to edit body of incoming email and forwarding it

    sorry for the double post, id also like to retain the original subject line without adding the "fw"
  8. D

    VBA to edit body of incoming email and forwarding it

    Hi all, I am trying to make a script / rule / combination of both that only occurs when i receive an email from a specific address. I would like to copy the body of the address and edit two things: • there is a hyperlink'ed word, "website" (see attached). I would like to change the address of...
Top