Nice. Thanks. I'll give it a try... Were you able to answer the two minor issues I have with my private subs?
Excel works but I need to grab the CC# at the top and haven't been able to do it inside the current pattern...
And I'm not sure how you make these apply to all emails in a folder...
I would like to run a script (that you already helped me with) to send Email information to Trello. I would also like to send a copy of that same information to an Excel Spread Sheet which I managed to do with some slight modifications of one of your sample scripts. My question is how do I run...
My Outlook VBS Script is correctly capturing and sending information from the body of my email to seperate cells in Excel however I need to capture a different piece of information near the top of the email and also send it and so I was thinking I needed a Reg2 to capture the correct pattern but...
My script seems to be running (and sending to Trello the same set of information) for each mail in the folder but it keeps sending the same information for the same email for each number of emails in the box...
Not sure what I need to change in my code?
I think it may have to do with this line...
My script seems to be running for each mail in the folder but it keeps sending the same information for the same email for each number of emails in the box...
Not sure what I need to change in my code?
I think it may have to do with this line but it errors when I remove it:
Set olMail =...
Two final questions. There is a space in the subject line before the subject and i'm not sure why and also you said earlier that this is a one message script. How do I change it to apply to all emails in a folder?
Ok here is what I finally came up with. It might be ugly but it works... :)
Two final questions. There is a space in the subject line before the subject and i'm not sure why and also you said earlier that this is a one message script. How do I change it to apply to all emails in a folder?
Sub...
This is just so weird because it should work but it doesn't! I must have something else wrong and I'm over looking it.
I even removed the move to specific folder and assign category just to make sure it wasn't messing it up.
Here is latest code. Maybe you can see something in the wrong place...
If I add searching for the ! then I only get ONE LINE
Without it I get the entire email body...
Case 2
.Pattern = "[!](\w*)\s*(.*)"
.Global = True
End Select
End With
If Reg1.Test(olMail.Body) Then
Set M1 = Reg1.Execute(olMail.Body)
For Each M In M1
strResult(i) = M.SubMatches(1)
Debug.Print...
well I tried this one:
.Pattern = "(\d*)\s*(.*)"
and it delivers the entire body of the text... If I add follows[:] then I get nothing.
Maybe it would be easier to remove the first part instead of capture the last part...
Any ideas would be greatly appreciated. I'm extremely frustrated at...
Ok so I've tried all the patterns I could find, the ones you suggested and ones that I've tried to put together but this is the closest I've gotten This will deliver the last word on every line that has a colon and I have no idea how that happened.
Set Reg1 = New RegExp
Set olMail =...
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.