Email list

[fixious]

Hello..The problem Im running into is I want a list of email addresses and when clicked these are the people this email will go to. If I only want to send it to one so be it but I want to be able to send it to everyone I click on. Any ideas or suggestions. This will be going into my database. Thank you

 

[PHV]

And what have you so far ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[fixious]

I settled for a simple SendObject put behind a command button for now but that doesn't give me the ability to add names to the Recipents line. I.E. If I have a max of 10 people on a list but only want to pick out a few or couple. Thanks for your time too.

 

[PHV]

Say you have a MultiSelect ListBox (lstEmail) which BoundColumn is an email address and a CommandButton (btnEmail).
You may consider like this in the btnEmail_Click event procedure:
strTo = ""
For Each varItm In lstEmail.ItemsSelected
strTo = strTo & ";" & lstEmail.ItemData(varItm)
Next varItm
If Len(strTo) > 0 Then
strTo = Mid(strTo, 2)
DoCmd.SendObject ....
End If

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244