How can I pass the result of strSQL into "Received_By" variable?
Thanks in advanceCode:strSQL = "SELECT Employees.[Employee ID], Employees.[Employee Name] " & _ "FROM Employees " & _ "WHERE Employees.[Employee Name] ='" & Received_By & "';" objMail.To = Received_By