After i get a recordset count
I'm trying to put the items into an array.
The array keeps coming up with only one item.
even though i have 10 records ?
' put the items into an array for emailing each row. dArrp = rs1.GetRows() ' just in case i need itd = rs1.RecordCountlngCount = UBound(dArrp, 2) + 1 For i = LBound(dArrp, 2) To UBound(dArrp, 2) ' my ubound always ends up being "one"