kulkasac
01-23-2009, 01:57 AM
Everyday I am receiving hundreds of mail containing header data and data about active users and concurrent users. I need to extract header information,active user and concurrent user data into excel from all mails. The data should append. For this I want a macro which will do this task.
Note: I kept all these mail into one folder. Plese see example of data
********Header information*******
ABC
PQRSTUVDF
123456
********End of Header information*******
---------------
--------------
----------------
Active Users 300
-------------------------
------------------------
Concurrent Users 10
----------------------------
Please help me!!! Thanks in advance....
Note: I kept all these mail into one folder. Plese see example of data
********Header information*******
ABC
PQRSTUVDF
123456
********End of Header information*******
---------------
--------------
----------------
Active Users 300
-------------------------
------------------------
Concurrent Users 10
----------------------------
Please help me!!! Thanks in advance....