Need to Copy Outlook 2010 Mail message to Excel 2010

Hi All,

I need help regarding update excel sheet based on outlook mail.

My objective is to update an excel sheet, whenever I am getting mails with a particular subject (I set up a rule for moving relevant mails to a folder).

I saw a similar post in this site, but didnt work for me. Being not a 'pro' or 'techie' its very difficult to write codes.

Subject: Task Completed (Created a rule for moving mails with this subject to folder Task Completed)

Mail contains:

Open: 35
Second: 10
HCQC: 60
HCQA: 40

There are 16-18 Activity like mentioned in above, but all activity will not be listed in single day. Content chages based on the activity performed on that.

I will get this mail daily and need to update this info in an excel sheet. (which i will keep open till the month end)

I have a excel dedicated to update this mail (Manually updating everyday), in which i have created 16-18 sheets with all activities and the sender's Name in each sheet with date.

Whenever i receive a mail VBA or macro has to automatically update particular sheet for particular name (Sender Name) for particular date (Sent Date)

Need to update excel with Sender Name, Sent Date, and Body of the mail in seperate cell

Please help me. Thanks in advance

Hi,

Can anyone help me on this issue.

All your help will be much appreciated

No one in this forum knws how to copy mail message to excel.

HTML Code: 

Please Login or Register  to view this content.