email workbooks to three people

[sybolt hoitinga]

Hi all,

I'm looking for code to send three workbooks to three different people via e-mail.
So, nine emails in total.

I have a column with three email-adresses and a column with three workbooknames.

Now, I need to automate the sending of the emails, because the workbooks have dynamic data, but the link to the dynamic data is not supported at the receiving end of the email.

Any help is much appreciated.

greets,


Sybolt