Hello Community

I try to create a macro to implement the following scenario (Excel2010):

1) the active sheet should be saved as a PDF
2) This PDF should be attached to an e-mail
3) the email addresses are stored in a sheet of the workbook and are assigned to each of the sheets which were previously saved as PDF.

each point individually "is almost not" aproblem. When I'm at work tomorrow I can post the code snippets, but maybe someone else has already achieved something like this.

thanks in advance!