Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: list to email


Message #1 by "Nikola" <Nikola@b...> on Thu, 20 Feb 2003 15:08:12 -0000
hi all,
from this code :

Private Sub lstMailTo_Click()
Dim varItem As Variant
Dim strList As String

With Me!lstMailTo
    If .MultiSelect = 0 Then
        Me!txtSelected = .Value
    Else
        For Each varItem In .ItemsSelected
            strList = strList & .Column(0, varItem) & ";"

        Next varItem
        strList = Left$(strList, Len(strList) - 1)
        Me!txtSelected = strList
    End If
End With
End Sub

how first selected email will be in one txt field and any another will go to
another txt field (txtBcc)

thanks


  Return to Index