Email Hyperlink to multiple addresses.

Hi
I'm using Excel 200 SP3

I've set up a hyperlink in a cell to open an outlook email message
dialog using the format:

mailto:graham@Blahdeblah.co.uk

Is there away to get it add multiple addresses in the To.. box?

Or to be even more fancy add some to thr To... & some to the Cc...

Thanks in advance

Dave F.

You could use a loop or build into an array.
Sub testlist()
For Each ce In [colj]
If Len(ce) > 1 Then mystring = mystring + ce.Value + ","
Next

MsgBox mystring
End Sub

Look here for more on email.

http://www.rondebruin.nl/

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Dave F." <df@buh.cu.uk> wrote in message
news:eO3SNyNdGHA.3996@TK2MSFTNGP04.phx.gbl...
> Hi
> I'm using Excel 200 SP3
>
> I've set up a hyperlink in a cell to open an outlook email message dialog
> using the format:
>
> mailto:graham@Blahdeblah.co.uk
>
> Is there away to get it add multiple addresses in the To.. box?
>
> Or to be even more fancy add some to thr To... & some to the Cc...
>
> Thanks in advance
>
> Dave F.