Dear users of Excel help forum,

I'm having a little problem to get something working. I'm the new treasurer of our study association, and once every 10 weeks I have to send all of our members a bill of all the activities they have participated in. Now, there are some 250 members, so I have to find something nice and easy 嫕d fast.

I've created a macro that lets met save the bill as a .pdf file, but now I want to take it a step further and let excel send an automated email (with the same message to everyone) to the one the bill is for, with the .pdf file as an attachment. The message will look a little bit like this:

Dear member,

Thank you for participating this semester, you can find the bill as an attachment.

Yours sincerely
I'll add my own workbook here so you can see what I have achieved so far. Please help me with this problem, I'd be forever grateful

Facturen Sv. IDent 2015-2016 Kwartiel 1.xlsm