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

  • Thread starter VB Script for Excel
  • Start date
V

VB Script for Excel

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, (e-mail address removed) and
(e-mail address removed).

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.
 
V

VB Script for Excel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy range C5:Lastrow and paste to two different worksheets 1
How to paste this down? 3
Paste to excel from word - auto format problem 1
Need Help with Macro Security 1
Copy/Paste (Clipboard) Issues 1
Visio shape text disappears upon copy paste 1
Synchronization problems while moving folders to new email 1
How do I set focus (and select text) on a text box on a modeless userform? 0

Top