[kefalo]

I need to extract some data from my inbox. In the body of emails that have a similar subject (only the receipt number is different) are the name and the email address of customers. The fields are always in the same place and the format of the email is completely standardized. I need to avoid going through the inbox and copy/pasting the needed data into Excel. Can this be done? Nenad

[Advertisements]

I'm pretty sure it can be done, most likely thru VB code. Are you familiar with VB - Visual Basic?

I've been using Access to populate some Excel spreadsheets, different but similar, with some neat VB code.

VB is not really for the faint of heart, but it's not impossible to use.

check these links:
http://blogs.techrep...msoffice/?p=744
http://www.dicks-cli...lRetrieving.htm

If the code in those links doesnt scare you too much , then some creative google searching should get you closer to your goal. If I had to pull data from emails into spreadsheets, that's the route I would take.

[Crowbar]

I'm pretty sure it can be done, most likely thru VB code. Are you familiar with VB - Visual Basic?

I've been using Access to populate some Excel spreadsheets, different but similar, with some neat VB code.

VB is not really for the faint of heart, but it's not impossible to use.

check these links:
http://blogs.techrep...msoffice/?p=744
http://www.dicks-cli...lRetrieving.htm

If the code in those links doesnt scare you too much , then some creative google searching should get you closer to your goal. If I had to pull data from emails into spreadsheets, that's the route I would take.

[kefalo]

found the tutorial for exactly what I need but I am not that tech savvy, will try anyway

here is the tutorial: http://blogs.techrep...msoffice/?p=744