I get 2 different emails from client every day. They have some trades
information in it. I wanted to create a macro that will copy all the
text in that email and paste it in the excel worksheet. These emails
come from a specific addresses.
Those email addresses would be, lets say, and
.

I use outlook express. Is there way that a macro could find that email
as it arrives, copy all the text from it, and paste it in excel sheet?

Please help.

Thanks a lot. This forum really helps.

Also, the macro should be able to pull up only today's trade emails. In
other words, it should pull up emails that were sent today. Because,
all the emails look same from past.

Regards

Hi VB Script for Excel

I use outlook express

You can run this program with Shell in VBA
http://www.oehelp.com/OEX/Default.aspx



--
Regards Ron de Bruin
http://www.rondebruin.nl


"VB Script for Excel" wrote in message oups.com...
I get 2 different emails from client every day. They have some trades
information in it. I wanted to create a macro that will copy all the
text in that email and paste it in the excel worksheet. These emails
come from a specific addresses.
Those email addresses would be, lets say, and
.

I use outlook express. Is there way that a macro could find that email
as it arrives, copy all the text from it, and paste it in excel sheet?

Please help.

Thanks a lot. This forum really helps.