Link to home
Start Free TrialLog in
Avatar of TOPIO
TOPIOFlag for United States of America

asked on

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
Avatar of TOPIO
TOPIO
Flag of United States of America image

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of shanesuebsahakarn
shanesuebsahakarn
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of TOPIO

ASKER

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