bsharath
asked on
Filter colum 'F" and send the user a mail with the details
Hi,
Need to filter as per managers and mail them with the A,B,C,D,E data
With headers in a border box
Filter colum "F" find a manager mail him his subordinate details .
Related to such output
https://www.experts-exchange.com/questions/23844631/Send-mails-to-users-in-the-excel-with-the-data-below.html?cid=239&anchorAnswerId=22797712#a22797712
Regards
Sharath
Full-Time-Internet-Users.xls
Need to filter as per managers and mail them with the A,B,C,D,E data
With headers in a border box
Filter colum "F" find a manager mail him his subordinate details .
Related to such output
https://www.experts-exchange.com/questions/23844631/Send-mails-to-users-in-the-excel-with-the-data-below.html?cid=239&anchorAnswerId=22797712#a22797712
Regards
Sharath
Full-Time-Internet-Users.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
try
doit = Mailem(cel.Value, rng3)
Cheers
doit = Mailem(cel.Value, rng3)
Cheers
ASKER
Thank U Dave worked perfect....
thx for the grade
ASKER
When debug goes here
Set doit = Mailem(cel.Value, rng3)