Link to home
Start Free TrialLog in
Avatar of bsharath
bsharathFlag for India

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
ASKER CERTIFIED SOLUTION
Avatar of Dave
Dave
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bsharath

ASKER

Thanks Dave. The first mail is displayed the the first 2 rows then get an Run time error 13 error
When debug goes here
  Set doit = Mailem(cel.Value, rng3)
try
doit = Mailem(cel.Value, rng3)

Cheers
Thank U Dave worked perfect....
thx for the grade