Something like this:

Dim rs as ADODB.recordset, strEmails as string, strSQL as string
strSQL = "SELECT MyEmail FROM MyTable WHERE MyHobby = 'Whatever'"
strEmails = vbnullstring
rs.Open strSQL,CurrentProject.Connection,adOpenForwardOnly,adLockReadOnly
while not rs.eof
  if strEmails = vbnullstring Then
     strEmails = rs.fields("MyEmail").value
  else
     strEmails = strEmails & ";" & rs.fields("MyEmail").value
  end if  
  rs.movenext
wend
rs.close
set rs = nothing
' strEmails now contains the Emails string

-Dorian

I am trying to do the same thing.  If I do a select all, copy, paste . . .
the field name is included with the data.  Is there a way to avoid the field
name from be included?