Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

E-mailing Access Reports through SQL Server Expand / Collapse
Posted Friday, April 18, 2008 4:43 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 13, 2009 10:13 AM
Points: 27, Visits: 82
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.
Post #487535
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse