Is it possible to e-mail reports defined in the access adp project, but call them through sql server? I want to be able to utilize the xp_sendmail command, but include e-mailing the reports from adp projects.
Currently, I have some VBA code I'm using to e-mail the three reports. But, I ran into an issue when I want to close the database window and run the tool as an application, the e-mail function complains, "The DoCmd.Output .... can not be found."
So, either I have to keep the database window open or use the docmd options to open and close the window when utilizing this e-mail function.
Any input would be greatful.