• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 206
  • Last Modified:

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
0
TOPIO
Asked:
TOPIO
  • 2
1 Solution
 
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
 
shanesuebsahakarnCommented:
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:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now