Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2003
    Thanked 0 Times in 0 Posts

    output to email (Access 2000)

    I have a report I want to email out as .RTF, a have a macro that performs the function perfect when you click the button, but the problem is there is a continous form on the page and if more than 10 materials are selected it then it becomes 2 pages and the headings get crazy on the RTF. Now when its 2 pages on the report, the report looks fine, no problem, its just when the it tries to convert to an RTF is the problem?? Any ideas to have the RTF look exactly as it looks in the report?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: output to email (Access 2000)

    Unfortunately, exporting a report to RTF is one of the weaker features of Access; the layout is usually not quite what you would like, and I don't know of any way to guarantee success. It has been weak from the start, and it hasn't been improved in new versions of Access <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>

    There is a format that preserves the layout very nicely: snapshot (.snp). The only drawback is that the recipient must install the snapshot viewer; this is a freely distributable free download from Microsoft - see Microsoft Snapshot Viewer Available in Download Center, but the advantage is that the recipient can view the report exactly as designed, and print it, but can't tamper with the contents.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts