How do I export email addresses from Excel to Outlook?

[Guest]

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

 

[KellTainer]

You could use this vba function which will produce a list of emai
address from a selection, and then dump it into B2, from which you ca
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 Su

 

[Guest]

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?action=getinfo&userid=34322
View this thread: http://www.excelforum.com/showthread.php?threadid=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