Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2008

    Unanswered: Multiselect List box to email code

    I have a form that I want to be able to select multiple users from one list box and add the query as an attachment from the other list box and email to multiple users. I have all the normal email code (hard coded), but am just having issues with the multiselect code. Any help in pointing me in the right direction would be greatly appreciated.

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    To retrieve the values of all selected rows in a multi-select listbox, you can use:
        Dim varItem As Variant
        For Each varItem In Me.<ListName>.ItemsSelected
            Debug.Print Me.<ListName>.ItemData(varItem)
        Next varItem
    With <ListName> being the name of the ListBox.
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts