Nitin Suntwal
New Member
Hi There,
I have created macro to create pdf & send salary slip to each employee. The code is creating pdf & attaching to gmail & sending for each person, its working fine. However, even when I add loop its working fine, but it is attaching other employees salary slips & sending mail. I thought to delete pdf after sending each mail, so I tried kill function but it is not deleting pdf from folder. I guess it is not deleting the pdf because the code is in loop.
Attached is the code in word document.
Any help!
Thanks,
Nitin Suntwal.
I have created macro to create pdf & send salary slip to each employee. The code is creating pdf & attaching to gmail & sending for each person, its working fine. However, even when I add loop its working fine, but it is attaching other employees salary slips & sending mail. I thought to delete pdf after sending each mail, so I tried kill function but it is not deleting pdf from folder. I guess it is not deleting the pdf because the code is in loop.
Attached is the code in word document.
Any help!
Thanks,
Nitin Suntwal.