You could use this vba function which will produce a list of email
address from a selection, and then dump it into B2, from which you can
simply copy over to outlook.

Sub emailList()

Dim emailList As String
Dim emailRng As Range

Set emailRng = Application.Selection

For Each c In emailRng.Cells
emailList = c.Value & ";" & emailList
Next

Range("B2").Select
ActiveCell.Value = emailList

End Sub


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=544300