Emailing workbook to 3 email addresses direct from excel

[jsac1984]

Hi all,

I am hoping someone can help me.

I have a 3 page workbook. The first page contains email addresses in A1,A2,A3.

The second page contains information, which I require to be able to be sent directly from within the spreadsheet.

I am hoping some one could help me with the code I need, so that if (for example) J1 was clicked on the information page, it would auto send to the 3 email addresses on the first tab.

I have managed a Macro, but from my understanding, this will only allow to be sent to one address? It also came up with an error after the first use.

I hope someone on here can help me!!

Thank you in advance

 

[Case_Germany]

Hi,

Ron has everything your heart desires - including sample files:

http://www.rondebruin.nl/sendmail.htm