Excel MAC 2011 send mail with sheet as PDF to list of contacts

Hi everyone, I have a workbook where I send in update quotes from the market to several clients, some clients have their own sheets with their own qualities, so I have one workbook with 3 sheets that will be mailed by PDF, another sheet with client names and e-mails - plus other sheets that are not related to this topic.


Today I use mailchimp for the big volume of clients (about 160-170 contacts), but it's not as "personal" as I want it to be, or as easy as just clicking one button. For the two other clients, I have a macro that will open the mail with the attached generated PDF and I manually type in the e-mail of my clients. I also

I have done some research online, and I did find something from ron de buin that would copy a row and send the row as attached excel. The way it uses the e-mailing is perfect, one e-mail per person plus having their name is awesome, but I cannot seem to make it work with the macro I have now. Besides sending the e-mail, I also like it to being saved on my dropbox folder in case I want to look back on the offers from other times, this works, it just saves the pdf with today's date on the same folder.

below is my macro:

Please Login or Register  to view this content.

I wanted to add the code to get the names and addresses like this:

Please Login or Register  to view this content.

Have attached my workbook as well, if anyone can help, I greatly appreciate it.

bumping my post to see if someone can help me, have continued to try on my own with no luck, am stuck on this.

If someone knows how I can send a mass mail of some sort via macmail like this, I would be very happy:

Please Login or Register  to view this content.

and have the below work, I can't seem to get it right, could someone please help?

Please Login or Register  to view this content.