Sending out 22 wage slips to individual staff email accounts using Excel Marco and Outlook

[balib_72]

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

[xenixman]

I'm a novice with Macros, but look here:

http://www.rondebruin.nl/win/s1/outlook/mail.htm

Should give you what your looking for.