You can email the report by writing a macro for the report. Use the (SendOject) action, object type (report), Output format (Rich Text Format), To: (whomever the report will go to) You can also just click on the File menu item and there is an option to Send. This is the simplest way I know without writing code.
Look at DoCmd.SendObject in Help<br><br>DoCmd.SendObject acSendNoObject, "", acFormatTXT, "ChrisC", , , "---------HOT ORDER-------", Redinfo, False<br><br>Also If you save it in Excel then Access can not view it directly.<br>You could Link the Excel sheet in the Tables TAB and create a report that you e-mail.<br><br>Excel and Access are not on a common file structure.<br>I would do everthing in Access and leave Excel out of the picture altogether.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.