How do I export email addresses from Excel to Outlook?

I'd like to create an Outlook email distribution list using email addresses
that are listed in one column of an Excel spreadsheet. What is the process?

Thanks
JasonLi

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" 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