Send a report using Access Runtime by mail.

I succesfully developed an application using access 2000 and installed on my en user machine using
access run time 2000 however when they create a report they want to send it by mail.

And the only option they have is to print it to a printer.
Is there a way to enable the  following commands in ART?

FILE -> Send to
FILE-> Export
LVL 10
TOPIOAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
shanesuebsahakarnConnect With a Mentor Commented:
The SendObject command can be used to send a report - but try to avoid it unless absolutely necessary.

You could also create a right-click (shortcut) menu for the report which has the send to and export options on it, and make that into the report's shortcut menu.
0
 
TOPIOAuthor Commented:
Programatically I tried to change the code by using
docmd.transferspreadsheet  acexport, acspreadsheetTypeExcel9, "RPT_TopRespiratory", "c:\temporal\temporalfile.xls"
but this method only works for a table and I have all the information in a query
0
 
TOPIOAuthor Commented:
I ended up using
DoCmd.OutputTo acOutputReport, , acFormatRTF
this will output the current report to a word file and you can
do wathever is necesary with that
0
All Courses

From novice to tech pro — start learning today.