Myztiques,

Your question is different from the example in the earlier post that you
quoted.  In that example, we were looking to reference the value for the
email from the current record on a form.  In your example, you could do
the same, if you had your query as the Record Source of the form, and
the form is open at the time that the email is sent.  Then you can do
the same idea that I suggested before, i.e. in the To argument of the
SendObject action in yyour macro, you can put like this:
=[Forms]![NameOfYourForm]![EmailAddress]
... and in the Subject argument, something like this:
="Congratulations, " & [Forms]![NameOfYourForm]![Borrower] & ", loan
number " & [Forms]![NameOfYourForm]![Loan Number] & " is approved"

Alternatively, you could reference the values from the query itself
using DLookup functions, so...

To: =DLookup("[EmailAddress]","YourQuery")
Subject: ="Congratulations, " & DLookup("[Borrower]","YourQuery") & ",
loan number " & DLookup("[Loan Number]","YourQuery") & " is approved"

To have the email open for editing before sending, set the Edit Message
argument in your macro to Yes.