Easy Listbox/ ComboBox Sendobject Problem

[CondtllyFrmttd]

I'm using MS Access v2003. I am trying to add a customer name and
their email address to a Listbox. The objective of this is to view
many customers and add them to an email using SENDOBJECT in the default
view.

I am having a hard time figuring this out, I guess I'm just bad at
this. I am considering SQL but have a tough time figuring out how to
insert it into code. Since the email will contain many names also
prob. need to add the ";" to the end of each name.

After doing some research I've come up empty. Can any MVP people
assist me?

 

[Ron Hinds]

You make your SQL the RecordSource of the ListBox. Each entry will be put on
a separate line automatically. Make the BoundColumn of the ListBox the eMail
address. If you want to send to everyone on the list, you'll need a Command
Button with code behind it to loop through the Items in the ListBox, calling
SendObject in the loop. If you want to be able to select individuals then
put the SendObject code in the DoubleClick event of the ListBox.