Multiple selection from within a listbox

  • Thread starter Thread starter ADixon
  • Start date Start date
A

ADixon

Hi all

I have a simple form based Access front end which is used to select some
existing info stored in tables, and also to gather user input. The info is
then sent to recipients via Outlook. I need to find a way of taking multiple
selections (also possibly single selections) from a listbox on a form and
placing it into the emails. As there is no way of knowing how many items
there are, how can i first take the info from the listbox, and second use
this info in Outlook?

Many thanks
 
(1) Define your listbox as multi-select (look in Access Help)
(2) Read thru the selected item collection to get the selections (look in
Access Help)
(3) Use the Outlook object to compose and send the emails.
(4) Expect to get a security prompt whenever you try to send an email via
Outlook and Access.

-Dorian
 
mscertified gave you the answer, but to find out how to loop through a list
box to determine which items are selected, see VBA Help for ItemsSelected
property.
 
Back
Top