VBA code for outlook to find serial number from excel

[RodrigoFinguer]

Hi, I am really not good to work with outlook codes, so here I am.

I have a list of serial numbers in a random column, let's say column B. I need to copy the code, and need to find in email body or subject in outlook, returning the e-mail who sent me and what time was it.

I think that's not that complicated, appreciate all your help, thanks!

 

[DanteAmor]

Sorry for this... but now i need a little different. Instead searching a code, I need the macro to select my subfolder called "Events", get the same information from e-mail, but this time I have not the serial, the macro will get the serial from the body, its located after the word "Event", example "Event Doc143445456", returning me just the second part. Also, it will get a name from the subject, after "-", example, "Event3 - NAME THAT I NEED".

Just try to help me, otherwise i will try myself, sorry bothering you!

Don't worry, but please create a new thread

 

[RodrigoFinguer]

I'm glad to help you

How can i extract a string between 2 strings knowing that my string contains 13 characters and starts after "Event" word.

 

[DanteAmor]

Es otro tema? puedes poner un ejemplo?