VB Query

C

Chris

I am running a query and outputting it into Excel then
sending the spreadsheet in an email in VB code. How do I
cancel the email from sending if the query returns no
records?

Thanks

-Chris
 
C

Chris Nebinger

IF DCOUNT("*","QueryName") > 0 then
'....Code to email it.
End IF


Chris Nebinger
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge skipping records/sending one at a time 0
Need Help with Macro Security 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Link a text box based on drop down box with four options MS Word 365 0
Can't send emails but can receive in Outlook 2019 1
Synchronization problems while moving folders to new email 1
VSTO C# add in Outlook.Appointment error 0
Creating a Chart on form from selected data in query. 0

Top