Auto mail from xl
 

I have a macro recoreded in one xl file which contains mail address
in
one column against particular client code in other column.

Macro is design in a such a way that it can send a file through mail
which is there on different worksheet containing sheet name as
respective client code.


Now my problem is that i have macro and lookup table in one sheet &
second file is of data wich contains the details of different client
code on different sheet. & i am not able to run that data file in my
recoreded macro, though it is working fine if the data & lookup table
in same file


Thnxs in advance
aMoL