Sending E-mails

[David Tunstall]

I have a code that when you double click the text box
[emailaddress], Outlook opens and puts whatever was in
the textbox in the To: line. Is there anyway that I could
say use a list box to select more than one email address
so that I can send the email to more than one person.

Thanks
David

 

[Pavel Romashkin]

Of course. You would need to use a loop and Selected property of the
list box, or, if you have A2002 or better, I think you can get the
contents of the list box into an ADO recordset and from that get all the
records into a comma separated list. Then, pass that to the SendObject method.

Pavel