Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Hope everyone are doing good, Am in need of your help.<o></o>
<o> </o>
I have created a payroll application using some VBA and worksheet functions as well, everything is working fine, but I am getting struck in pay slip processing, for Payslip creation I created one sheet and used vlookup function, if I key in the employee number, all other particulars will update, and I have created a mail icon which converts that particular range to pdf and generates email, now its becoming very difficult for me to do the same action for all employees.<o></o>
<o> </o>
So am looking where macro automatically runs and generate email for all at a time, below is the more details<o></o>
<o> </o>
Ex:-<o></o>
Sheet name “payslip” in cell “A5” I need to update the employee number, I have the list of applicable employee numbers in sheet “Maillist” from “a2 to X (xldown / end)”, now I want to write a code where it works as<o></o>
1. Copy from sheet “Maillist” cell “a2” and paste in sheet “payslip” cell “A5” and then run the mailer code(converts in to pdf and generates email)<o></o>
2. Copy from sheet “Maillist” cell “a3” and paste in sheet “payslip” cell “A5” and then run the mailer code(generate email)<o></o>
3. Copy from sheet “Maillist” cell “a4” and paste in sheet “payslip” cell “A5” and then run the mailer code(generate email)<o></o>
.<o></o>
.<o></o>
.<o></o>
.<o></o>
.<o></o>
Copy from sheet “Maillist” cell “a100”(xldown) and paste in sheet “payslip” cell “A5” and then run the mailer code(generate email).<o></o>
<o> </o>
<o> </o>
I have the code which automatically convert particular range to pdf and generates email, can anyone help me to get the above code..<o></o>
<o> </o>
Thanks in advance<o></o>
<o> </o>
Regards,<o></o>
GV Reddy<o></o>
<o> </o>
Hope everyone are doing good, Am in need of your help.<o></o>
<o> </o>
I have created a payroll application using some VBA and worksheet functions as well, everything is working fine, but I am getting struck in pay slip processing, for Payslip creation I created one sheet and used vlookup function, if I key in the employee number, all other particulars will update, and I have created a mail icon which converts that particular range to pdf and generates email, now its becoming very difficult for me to do the same action for all employees.<o></o>
<o> </o>
So am looking where macro automatically runs and generate email for all at a time, below is the more details<o></o>
<o> </o>
Ex:-<o></o>
Sheet name “payslip” in cell “A5” I need to update the employee number, I have the list of applicable employee numbers in sheet “Maillist” from “a2 to X (xldown / end)”, now I want to write a code where it works as<o></o>
1. Copy from sheet “Maillist” cell “a2” and paste in sheet “payslip” cell “A5” and then run the mailer code(converts in to pdf and generates email)<o></o>
2. Copy from sheet “Maillist” cell “a3” and paste in sheet “payslip” cell “A5” and then run the mailer code(generate email)<o></o>
3. Copy from sheet “Maillist” cell “a4” and paste in sheet “payslip” cell “A5” and then run the mailer code(generate email)<o></o>
.<o></o>
.<o></o>
.<o></o>
.<o></o>
.<o></o>
Copy from sheet “Maillist” cell “a100”(xldown) and paste in sheet “payslip” cell “A5” and then run the mailer code(generate email).<o></o>
<o> </o>
<o> </o>
I have the code which automatically convert particular range to pdf and generates email, can anyone help me to get the above code..<o></o>
<o> </o>
Thanks in advance<o></o>
<o> </o>
Regards,<o></o>
GV Reddy<o></o>