Excel X Outlook!

FefaBr
06-04-2010, 07:16 AM
Hi Guys, New here in the exciting world of VBA programation, hehehe!

Here is my problem:

I receive about 800 emails/week about the same thing (and all goes to one file). I just need the "string" that comes after the letters "CPF" in the email text (sometimes it's a number, sometimes a string (like: 215 124 795 - 15), sometimes there is a ":" after "CPF", so I can't call it as long.

I need to take this "number" (the string after "CPF") and add to an excel (new one). So it would be a list with all strings. (about 800/week)

The emails are inside the file "Pastas Particulares9", inside the "week.month" (like 4.may, if it's the 4th week of may). And I receive this file complete, from another guy.

Can someone help me?

(i saw something like this in: http://www.xtremevbtalk.com/showthread.php?t=119633), but i couldn't change to my necessity...

Here is the "structure":

open an excel file
"open" the file "Pastas Particulares9/4.may"
search "CPF" in the text of the email
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)
(and again, again, again...)

Thaaaaaaaaaaaaaanks!

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum