ExcelBanter - View Single Post - How do I export email addresses from Excel to Outlook?

"KellTainer" wrote:

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

Thanks. Not being a programmer, I'll have to defer your recommendation to one of our programmers and hope that it will work.
Thanks again,
JasonLi