Rick, I have created an unbound listbox of customer orders that is populated by assigning the following SQL statement to the Data.RowSource:

SELECT OEORDHDR_SQL.ord_no, OEORDHDR_SQL.cus_no FROM OEORDHDR_SQL ORDER BY OEORDHDR_SQL.ord_no;

The user clicks on the orders he/she wants to preview in a confirmation report, then clicks a "Preview" button that has the following VBA code:

Dim strwhere As String
    If (IsNull(List9.Value) And List9.ItemsSelected.Count = 0) Then 'NO ORDERS SELECTED
        strwhere = ParseWhere
    Else
        Dim I As Variant
        strwhere = ""
        For Each I In List9.ItemsSelected
           strwhere = strwhere & "ord_no = '" & List9.ItemData(I) & "'" & " OR "
        Next
        strwhere = Left$(strwhere, Len(strwhere) - 3)
    End If

    DoCmd.OpenReport "Order Confirmation", acPreview, , strwhere

Now I want to create an email to send this confirmation to the customer.  Do I use the SendObject command, and if so, how do I pass the parameters to it?

---

Reply from Alex Hedley:

Follow this Tip.
Or Expert Level 5 for a full explanation.
Or if you really want to use Emails to their full potential use the Access Email Seminar.