Email DLookup to show all records

N

Nick W

I have composed an email which is generated from a command button. I
have used DLookup to create the subject using Job Reference and title
from a query. What I now need to do is to list all applicants that the
query throws up within the email. I have used the DLookup function
which only shows the first Applicant Name, however for the example I
have used there are 3 applicants. Any suggestions on how I can do
this? Here's the details of the vba behind the button, if further
details are needed to be able to help please let me know

DoCmd.SendObject acSendNoObject, "", "", "", "", "",
DLookup("[JobID]","[QryDisabledEmail]") & " - " &
DLookup("[JobTitle]", "[QryDisabledEmail]"), "EMAIL TEXT"& Chr(13) &
Chr(13) & DLookup("[Applicant Name]","[QryDisabledEmail]"), True, ""

Thanks in advance
Nick
 
Top