Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    ca
    Posts
    1

    Unanswered: Sendobject Question

    Hi

    I e-mail a weekly error report from Access to my colleagues at work. The report comes from a query in a Macro using the sendobject command, and is e-mailed in Excel format.

    My question is: Is there anyway to prevent the file being sent when the query is blank? I have attached a screenshot from the macro.

    Many Thanks
    Ed Chambers
    Attached Thumbnails Attached Thumbnails 1.jpg  

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    This would be simple in a module. Just a quick dcount and an if statement or a recordset.movelast and an if statement. I saw a message on this board this afternoon about this...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •