Deepu,

KISS:
dont program..
create a rule in Outlook to alert you.
then do whatever needs to be done manually.

Else:

Classmodules are for experienced programmers only.
I dont want to sit down and write the complete code for you.
maybe by googling you may find a more appropriate example.

If you have enough experience than you can analyse
my earlier code and adapt as needed with relative ease.

create a classmodule in excel.

the class must logon/start outlook when instantiated.
the class must monitor the newmail event in outlook.
and run a procedure when the event is triggered.

the class must terminate the outlook.application variable
when it (or it's container) is terminated

my earlier code does similar things.. but reacts to seach_complete
event.





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Deepu wrote :


Hi KeepitCool,

Thanx a ton for your reply. And you guessed it rightly it all sounds
abracadabra to me..


I want a macro to be triggered whenever a mail comes from a specified
source with an attachement. And I don't want to search my inbox for
the existing mails, as I want to automate this for future course of
action.

Well I don't expect you to explain the code, but atleast guide me
where to use this code..

Thanx for your time.