Excel Excel X Outlook! - Copiar e colar

Jul 5, 2010
Reaction score
[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]



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Outlook 2003 red X's 0
Word TICK in Word form field - not the X check box 0