View Full Version : Get Data from Email Body (Outlook express)


wazza
08-30-2006, 05:14 AM
Dear All

I have expereince in VBA Excel. I also run an estate agents, I am stuck in a loop of inputting lots of data manually to my spreadsheet from client emails. I recieve automated emails (fixed template) from verious website portals containing client details.

We are talking about 100-200 emails per day - taking me 2-3 hours to upload to a spreadsheet where I manage enquiries. I could do with REMOVING this task.

Pls pls pls help. This is something i really want to remove. Is it possible to write a VBA script that will run from Excel, open my emails in a certain account and collect the body of the email.. I will probably then write a script in Excel to find certain key words like 'Name' & 'Telephone' where i will find the variables which follow.

Please help - my only day off today - and i would like to get a solution sorted before i get stuck in my day-to-day tasks again.

Kind Regards

Warren - London, England.

wazza
09-01-2006, 02:59 AM
Iv had no replys... anyone suggest another forum or info source?

thanks

shades
09-03-2006, 05:05 PM
For specialized VBA like this, perhaps the best place to go is: VBA Express (http://www.vbaexpress.com/). Some of the Microsoft MVPs are regulars there.