Search results

Hi I have the following code where the strSQL Query selects records based on date, all works ie emails go off except the query doesnt select the records with the date = rdate. Please could you let me know the format of this line : ((Accounts.Date)=" & strCondition1 & ") . I have put strCondition...

Hi thanks for the reply. I changed that and it seems that the email address from Send_Monthly_Invoices which is correct is being brought in as a 0 in SendInvoiceEmail.

Hi I have a Sub that runs through my Reservation and Accounts tables (query) and prints out a report/invoice for that reservation. Then I wanted to email it to that person using the EM Address field in the same query. This is the code that runs through my query : Option Compare Database...