On Sun, 10 Oct 2004 21:09:58 +0000 (UTC), "Mark \(InWales\)"
wrote:

Hello to the great and good

Two questions;


2). I have a userform created in VBA and I was wondering how to put a live
mailto: link in? Currently I have the email address on the form in a
textbox... but it doesn't work!

Hi Mark in Wales.

I have a spreadsheet that copies itself to a new workbook and then
sends the copy to a n=umber of email addresses. The code is as follows

ActiveSheet.Copy
Set wb = ActiveWorkbook
With wb
..SaveAs Fpath & Format(Range("c2"), "dd-mmm-yy") & ".xls"
.SendMail ", Format(Range("c2"), "dd-mmm-yy"), True

You may only want to use the send bit of the code. Hope this helps.

Peter in Wales also
--
Cheers

Peter

Remove the INVALID to reply