Hi All, I am a new member here.

I need to send out 22 pay slips to 22 staff via email every Friday.
I am hoping I can automate this process using excel and the powers of Marco's.

I have a list of 22 email accounts and wish to link the correct PDF wage slip (can be picked from a folder location)
to each staff member and then to automatically send out all the emails.

I am new to Marco but hoping someone with experience can show mw how this can be done.
I have MS 2007 (Excel 2007 and Outlook 2007)

Many thanks

Bal