Email Query Results

[mlr0911]

Hello,

I have the following code kicking off an email based on a query result:

DoCmd.SendObject acSendReport, "Transaction Notice", acFormatTXT, "jams@corwell.com", "sweeny@corwell.com", , "Transaction Notice", "The following fees were reported on today's report." & Chr(13) & Chr(13) & _
Chr(13) & Chr(13) & "Thank You" & Chr(13) & Chr(13)

What I need help with is if the above report (query) doesn't have any data, don't send the email.

How would I accomplish this?

Thanks for your help.

 

[rainman89]

you could do a

if isnull(yourdatefield) then
msgbox "please enter a date"
else
DoCmd.SendObject acSendReport, "Transaction Notice", acFormatTXT, "jams@corwell.com", "sweeny@corwell.com", , "Transaction Notice", "The following fees were reported on today's report." & Chr(13) & Chr(13) & _
Chr(13) & Chr(13) & "Thank You" & Chr(13) & Chr(13)
end if

 

[mlr0911]

rainman thanks for your help......

 

[GaryPanic]

hmm if x = > 1 then run qry ???

so run your qry with a total in it and if that field is >1 then run qry
if its not then don't ?

thinking out loud here really

 

[KeithG]

Use the Dsum on the reports recordsource to count the records. If the value returned is greater than zero send the email.

 

[shaunburke]

you could do a

if isnull(yourdatefield) then
msgbox "please enter a date"
else
DoCmd.SendObject acSendReport, "Transaction Notice", acFormatTXT, "jams@corwell.com", "sweeny@corwell.com", , "Transaction Notice", "The following fees were reported on today's report." & Chr(13) & Chr(13) & _
Chr(13) & Chr(13) & "Thank You" & Chr(13) & Chr(13)
end if

Could you help me to understand what's happening in this code? I have little programming experience. What's happening here. It looks like it will send an email when certain criteria is met.

 

[rainman89]

Could you help me to understand what's happening in this code? I have little programming experience. What's happening here. It looks like it will send an email when certain criteria is met.

thats correct,
its checking to see if there is a date in the field, which would mean the qry has data in it then it is sending the email to the specified people