[font='Verdana','sans-serif']Hi Guys!
Can someone help me with this big challenge?
I receive a outlook file with +- 800 emails/week about the same thing.
Always, there is the letters "CPF", and I need to take what is after "CPF". Sometimes it's a number, sometimes a string (like: 215 124 795 - 15), sometimes there is a ":" after "CPF", so I need this string, and in the excel I transform it in a number (as long).
I need to copy the string after "CPF" and paste it in an excel (a new one). So I would have a list with all strings.
The emails are inside a file (1.2) that is inside another file (Pastas Particulares9),.
Can someone help me?
(i saw something like this in: [/font][font='Verdana','sans-serif']http://www.xtremevbtalk.com/showthread.php?t=119633[/font][font='Verdana','sans-serif']), but i couldn't change to my necessity...
Here is the "structure":
open an excel file
search "CPF" in the text of the email of the file 1.2
take all after "CPF" (until the end of the line)
copy this to one cell in the excel file
go to the next email (look all the emails of this file)
go to the excel cell after (like lin=lin+1, loop...)
(and again, again, again... until the end of the file)
Thaaaaaaaaaaaaaanks! [/font]
Can someone help me with this big challenge?
I receive a outlook file with +- 800 emails/week about the same thing.
Always, there is the letters "CPF", and I need to take what is after "CPF". Sometimes it's a number, sometimes a string (like: 215 124 795 - 15), sometimes there is a ":" after "CPF", so I need this string, and in the excel I transform it in a number (as long).
I need to copy the string after "CPF" and paste it in an excel (a new one). So I would have a list with all strings.
The emails are inside a file (1.2) that is inside another file (Pastas Particulares9),.
Can someone help me?
(i saw something like this in: [/font][font='Verdana','sans-serif']http://www.xtremevbtalk.com/showthread.php?t=119633[/font][font='Verdana','sans-serif']), but i couldn't change to my necessity...
Here is the "structure":
open an excel file
search "CPF" in the text of the email of the file 1.2
take all after "CPF" (until the end of the line)
copy this to one cell in the excel file
go to the next email (look all the emails of this file)
go to the excel cell after (like lin=lin+1, loop...)
(and again, again, again... until the end of the file)
Thaaaaaaaaaaaaaanks! [/font]