VBA to send multiple emails with different attachments

Hello all,

I just had a post solved today that sent multiple emails at once all with different ranges in each body. The location of this post: http://www.excelforum.com/excel-prog...end-email.html .

I also need a similar code, that instead of sending each email with the range as the body, I need each range as the attachment. Can anyone help? Please see link above for sample workbook format.

I have looked at these before. I am not very good with VBA, and the only one close is the one to mail a range as an attachment. My problem is, I need to mail many different ranges to many different email addresses.