Mick
Browse through Ron deBruin's sendmail site.
Code and the free download of SendMail add-in.
http://www.rondebruin.nl/sendmail.htm
Gord Dibben MS Excel MVP
On Sat, 26 Aug 2006 07:39:27 +1000, "Mick" <zep55[ at ]ozemail.com.au> wrote:
[Quoted Text] >Gday,
>
>I have one set of data that will feed approx. 25 worksheets for a monthly
>report, with each worksheet going to seperate customers. Can I put a
>hyperlink to the email recipients so that when I run data and get report, I
>say click on hyperlink in cell A1 with email adddress and it will drop that
>worksheet only into an email ????. This is rather than copy individual
>sheets, send as attachment, then search for mail recipients.
>
|