Recent content by joe1250

  1. J

    Is this possible to do with a macro?

    Hi Diane, I just wanted to let you know that I've also posted a question on Mr. Excel pertaining this thread and the topic of how I might tackle the array issue. I'm not sure how busy you are this time of year so I figured I'd ask around over there in case you're unavailable. Just wanted to let...
  2. J

    Is this possible to do with a macro?

    Hi Diane, I hope you had a wonderful holiday season! I'm still a bit stuck on how to use an array here and was hoping if you had time you might be able to push me in the right direction? Thanks, joe
  3. J

    Is this possible to do with a macro?

    Thanks Diane, I spent the bulk of the day yesterday (and will do so today as well) working on this and trying out different things. While I'm no closer to making something that does what I need, I have learned a lot about the Regex object and how it works... very cool, I hope I am able to learn...
  4. J

    Is this possible to do with a macro?

    would it make sense to use an array? maybe something like Dim arr arr = Array("Case 1","Case 2","Case 3") I'm not sure exactly how to incorporate this, but seemed like maybe it would treat them as groups of pattern matches rather than individual pattern matches? Then maybe could do a count...
  5. J

    Is this possible to do with a macro?

    Interesting... when i create the 6 case statements and set .Global = True, I do get all of the values, but not in the right sequence... so rather than (Case 1,2,3), (Case 1,2,3) I get (Case 1,1), (Case 2,2), (Case 3,3)...
  6. J

    Is this possible to do with a macro?

    ok, so I would create as many Cases to suite the most likely highest number of possible occurrences? Seems like there be some way to count... so if a "match set" = cases 1 through 3, and the macro counted there were 3 "match sets" in the message, then I could tell it to run the loop 3 times...
  7. J

    Is this possible to do with a macro?

    Just occurred to me that as long as I was able to save the testSubject(1,2,3...i) variables, I could use them at any point to create the FldrLvl variables... ie... or something like this... just as a concept, I know the syntax is probably wrong, I'll have to go figure it out... FldrLvl1 =...
  8. J

    Is this possible to do with a macro?

    Thanks Diane, so I'm a bit stuck at the moment trying to figure out how to get the code to loop through to look for other instances of matches for the patterns in the email. Right now it finds the first set of 3 matching patterns and correctly identifies the values, but then exits the loop and...
  9. J

    Is this possible to do with a macro?

    figured out this missing Case 3 value... capitalized N in number should have been lower case :0
  10. J

    Is this possible to do with a macro?

    Thanks so much for all your advice so far Diane, I really appreciate it :) For some reason that last sub doesn't apply to the whole message (unless it does, but I can only see the top section that fits in the message box? can't seem to scroll or resize the message box to see if it continues...
  11. J

    Is this possible to do with a macro?

    Thanks Diane! so this is a screenshot of the part of the table in the body of the message that contains the relevant info I need to create the folder structure... the whole table is larger with other details, but this all I really care about at this point. So when you say do mean the whole...
  12. J

    Is this possible to do with a macro?

    I am "familiar" with creating (and recording) macro's in Excel, but don't really know a lot about how to get the most out of Outlook (2007). This time of year, we get a lot of emails generated from a webform on our website and we are then required to create folders on our server for each email...
Back
Top