Search results

At the beginning of this thread I included two scripts that I'm running. inside the documents are an issues at the top.

I was in the same thread... Not sure what happened or where it went...???

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 do see there are two case 15's

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 one opens up an email.. puts in the correct to address and subject but has no body

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 =...

Ok this one gave me nothing... . Pattern = "(request follows(.*))" This one gave me one line only.. Case 2 .Global = False .Pattern = "request follows[:](\d*)\s*(.*)" .MultiLine = True End Select

Ok I changed it to this and got one line in the subject Case 2 .Global = False .Pattern = "request follows[:](\d*)\s*(.*)" .MultiLine = True End Select

HOUSTON WE HAVE A SUBJECT! WHOO HOOO.... Still no body yet but brought up the window, put in the to: and put in the subject (without the FW like I needed)

like this: Sub ForwardProjectcard() Dim olMail As Outlook.MailItem Dim Reg1 As RegExp Dim M1 As MatchCollection Dim M As Match Dim strResult(2) As String Dim strSubject, strFollows As String Set Reg1 = New RegExp Set olMail = Application.ActiveExplorer().Selection(1) For i = 1 To 2...

Actually the email is sent and the subject is BLANK and the contents is BLANK and only the first one gets category assigned. But IT DID RUN! ug. Sub ForwardProjectcard() Dim olMail As Outlook.MailItem Dim Reg1 As RegExp Dim M1 As MatchCollection Dim M As Match Dim strResult(2) As String Dim...