parse the next line in outlook


If intLocLabel > 0 Then
       strText = Left(Trim(Mid(strSource, intLocLabel + 14)), 9)
       intLenLabel = Len(strText)

parses a 9 digit number just after my key phrase, how would I parse all the information on the next line?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Naveen SwamyYash Infinite Solutions Private LimitedCommented:
not clear with your question???????
i think we need to know some more about the formatting....

however to speed this up, you can place $ signs right to Left,Trim and Mid like this:

strText = Left$(Trim$(Mid$(strSource, intLocLabel + 14)), 9)

that is about 20% faster
bpfsrAuthor Commented:
Sorry - what I'm saying is I use the code above to parse a particular number from the same line as the LocLabel. In this case it is a reference numbers, so I am searching for the phrase "reference #:" and then parsing the number itself, which always falls immediately after "reference #:" and is always on the same line. However, I want to seperately parse, for insertion somewhere else, the line beneath "reference #:". So if  - strText = Left$(Trim$(Mid$(strSource, intLocLabel + 14)), 9) - gives me the number following "reference #:", how do I get the line beneath it?

you can search for a vbcrlf (linebreak)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.