I found this code and use it send mail (it loads the mail Program)and lets users send you a email. I know it does not answer you question but unless you use VB I do not know how a number of names to a email list.
Option Compare Database
Option Explicit
Private Const HH_mailto_Dialog As Integer = 6
' Declarations to call the default browser
Private Const SW_SHOWNORMAL = 1
Private Declare Function CxtWebHelp Lib _
"shell32.dll" Alias "ShellExecuteA" _
(ByVal hwnd As Long, _
ByVal lpOperation As String, _
ByVal lpFile As String, _
ByVal lpParameters As String, _
ByVal lpDirectory As String, _
ByVal nShowCmd As Long) As Long
Public Sub ShowHelpContext(hwnd As Integer, nContextId As Integer)
Dim strTopic As String
Dim strFullPath As String
Dim strPathOnly As String
' Display help via the HTML Pages of the WebHelp directory or
' URLs of the WebHelp topics
Select Case nContextId
Case HH_mailto_Dialog
strTopic = "mailto:YOURNAME@YOURSITE.COM"
Case Else
strTopic = "notfound.htm"
End Select
' Get the path to the database
strFullPath = CurrentDb.NAME
strPathOnly = Left$(strFullPath, Len(strFullPath) - Len(Dir(strFullPath)))
CxtWebHelp hwnd, vbNullString, strTopic, vbNullString, _
strPathOnly + "\WebHelp\", SW_SHOWNORMAL
End Sub
' These next two functions are called via two Runcode macros
' that are in-turn called by items on the WebHelp menubar/toolbar.
' Note that the first argument is 0 since the menus can't pass
' the correct window handle.
Public Function ShowContents() As Long
ShowHelpContext 0, 5
End Function
Public Function EmailEhelp() As Long
ShowHelpContext 0, 6
End Function
