Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2002
    Posts
    3

    Unanswered: Mail Report as Word document.

    Does someone know how to mail a report as a Word document ?

    The AcFormat Type does not include Word.

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    Output the report as RTF. This can be read by Word. ALternatively Output the file as RTF and then open with word and save as a doc.

  3. #3
    Join Date
    Jun 2002
    Posts
    3
    My problem is that using RTF format will loose all graphics (lines...) settings. RTF is a pretty rough formatting solution.

    Any other clue ?

  4. #4
    Join Date
    Feb 2002
    Posts
    403
    There is no way I am aware of to retain report graphics except as a snapshot report.

  5. #5
    Join Date
    Jun 2002
    Posts
    3
    Ok, thanks very much.

    That's the way I actually defined the output. As this report is mailed to Suppliers I included a comment to ask to download the Snapshot Viewer from Microsoft Web site. This is not the best way as people are not allways very aware on how to do these kind of things.

    Any clue, any time will be welcome.


    Thanks you again for your input

  6. #6
    Join Date
    Nov 2001
    Posts
    336
    Hi,

    If you have PDF printer inatalled then you may also consider PDF format.
    Just print your report using PFD Printer.

    Just my 2 cents.
    Igor

  7. #7
    Join Date
    Apr 2002
    Posts
    139
    Alternatively you can use the hard but superb flexible way:

    In Word:
    1) create your report layout as a template (.dot);
    2) place bookmarks wherever you want to insert data;

    From Access code:
    3) write automation code to open an instance of Word;
    4) code to create a new Word document, based on your template;
    5) code to loop trough your recordset and the Word-bookmarks;
    6) code to insert data in the Word document where appropriate;
    7) code to save the Word-document;
    8) code to email the Word-document.

    Takes some time to figure it all out, but gives you all the Word-features.
    Definitively worth the effort.

Posting Permissions

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