How do I export email addresses from Excel to Outlook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
KellTainer said:
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.
Click to expand...
Thanks again,
JasonLi
 
Back
Top