software

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 amp; quot;;quot; amp; emailList
Next

Range(quot;B2quot;).Select
ActiveCell.Value = emailList

End Sub--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: www.excelforum.com/member.php...oamp;userid=34322
View this thread: www.excelforum.com/showthread...hreadid=544300

quot;KellTainerquot; wrote:

gt;
gt; You could use this vba function which will produce a list of email
gt; address from a selection, and then dump it into B2, from which you can
gt; simply copy over to outlook.
gt;
gt; Sub emailList()
gt;
gt; Dim emailList As String
gt; Dim emailRng As Range
gt;
gt; Set emailRng = Application.Selection
gt;
gt; For Each c In emailRng.Cells
gt; emailList = c.Value amp; quot;;quot; amp; emailList
gt; Next
gt;
gt; Range(quot;B2quot;).Select
gt; ActiveCell.Value = emailList
gt;
gt; End Sub
gt;
gt;
gt; --
gt; KellTainer
gt; ------------------------------------------------------------------------
gt; KellTainer's Profile: www.excelforum.com/member.php...oamp;userid=34322
gt; View this thread: www.excelforum.com/showthread...hreadid=544300
gt;
gt; 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