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.
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...
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!
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...
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.