how do i find an email and copy the text and paste into excel sheet
 

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.

how do i find an email and copy the text and paste into excel sheet
 

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

how do i find an email and copy the text and paste into excel sheet
 

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.