Please let me know how can i send the payslip to employees in the PDF format to the e-mail id maintained in the sheet1(emp deatils) it should select email ids automatically from the sheet1 to respectively
i have sheet1 in that having employees details how can i do this help me out i have attached my excelsheet
Hi Baig,
I can't see the email id on sheet 1. can you please clarify?
Thanks
Lex
Sorry its in sheet2
Hi,
Just added a few lines , copy and paste it to your excel and this should work.
Formula:
Please Login or Register to view this content.
Cheers,
Lex !!
i am getting this error Run-time error '1004':
Unable to get the Vlookup property of the WorksheetFunction class
in this line
B = WorksheetFunction.VLookup(Sheets("sheet1").Range("AE" & rCell.Row).Value, Sheets("sheet2").Range("A:E"), 5, False)
Last edited by baig123; 06-13-2014 at 06:16 AM. Reason: paragraph
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks