Recent content by Guy

  1. G

    Parsing All Emails

    Diane, thank you very much. I have made adjustsment per your suggestions and it runs perfectly. I have also read through your suggested readings. Very helpful and informative. Much appreciated.
  2. G

    Parsing All Emails

    Awesome! I knew there had to be a better way. Terrific. Thank you.
  3. G

    Parsing All Emails

    Thanks again Diane. This all seems to be working nicely, however there is one spot that I find very odd that I have had to put into the code and that is getting the body text. If I don't display the email (InboxItem.Dsplay) and then pause the routine (Pause 1) VBA seems to "miss" the...
  4. G

    Parsing All Emails

    Thanks Diane, this helped a lot. I did fail to mention that the email frequency will be quite low. 5 per day max. Maybe 2 at once per server request kind of thing. Really like this forum - it has been a huge help over the years!
  5. G

    Parsing All Emails

    I have an Outlook client that is always running, on a machine always logged in. It uses a special email address and it's not a person. We use this email as a "traffic cop" that captures inbound mail from disparate business systems inside the building and then through VBA executes certain...
  6. G

    Adding an attachment to email I just created (VBA)

    What do I need to add to the code below to get an Excel doc attached to the email about to be sent? (About two thirds the way down the page see red text). TIA. Sub ParseEPDMRequest(Item As Outlook.MailItem) 'parses inbound email using Regular Expression tools and returns required number of...
  7. G

    Rule starting a VB macro against incoming email

    If I use this code - Set olMail = Application.ActiveExplorer().Selection(1) it uses the selected email in Outlook. But the email I need to parse is not showing in the Inbox - how do I attach to something that has not appeared in the Inbox yet, but has tripped the rule and therefore the macro? Thx.
  8. G

    Rule starting a VB macro against incoming email

    I have a rule looking at the Subject line for a certain phrase. When an email comes into Outlook the rule starts a macro with the following name: Sub Check_For_EPDMnumbers(Item As Outlook.MailItem) I cannot get this routine to run against the email that triggered the rule. It runs against the...
Top