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

How do I export email addresses from Excel to Outlook?
 

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

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