• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA to attach specific files in outlook

Hi,

Is there any one can help me to solve my issue?
I have created a tool to send email to each of staff in one organization regarding their payslip.
To do that i have created loop in VBA. Unfortunately, some of staff doesn't have email, so we need to send to their manager. By using loop, managers will get several email according to number of their staff who doesn't have email. All i need is to send just only one email by attaching all pay slip of staff who doesn't have email.

Please view my attached file as example.
Much appreciate for your help.
Chanthan
 

Attachments

  • VBA-Email.xlsx
    9.9 KB · Views: 4
Back
Top