Email Hyperlink to multiple addresses.

D

Dave F.

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:[email protected]

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.
 
D

Don Guillett

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/
 
Top