Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2003
    Posts
    5

    Red face Unanswered: Email an Access Report Part II

    I need to email 131 reports from Access to 131 different project managers. However, the reports will need to be updated by the recipients. Ideally I would have liked to produce the report in Word so they could update the relevant sections but the report is based on at least 3 fairly complex queries. I can export a report with subreports from Access to Word but lose all the formatting this way. I have noticed Steve Arbaugh's suggestion to a similar question to use PDF files but these can't be updated by recipients without Acrobat Writer... any ideas?

    I've been tearing my hair out trying to think of different ways to do this, it's driving me mad!!!

  2. #2
    Join Date
    Jun 2002
    Location
    Vienna, VA
    Posts
    53
    Here's a suggestion - format the reports for Excel then email them using Excel. Then, instructions can be sent as to how to record changes, so that when they return the email spreadsheet, you can easily pick up the changes via automation. Automation with Excel is not very difficult, and there should be plenty of resources both online and in the various access books to help with this.

    Just my two cents.

    Leah

  3. #3
    Join Date
    Mar 2003
    Location
    Southington, CT
    Posts
    8
    Could you set up a document in Word that pulls information from your Access query via a Mail Merge? You could then set up Fill-In fields and Text Form Fields that your managers could adjust as neccessary?

    Jonathan

  4. #4
    Join Date
    Mar 2003
    Posts
    5
    I tried to do a Word Mail Merge but as far as I can work out you can only base this on one Access Query and I would need to base it on at least 3 separate queries.

    What a nightmare! I rang Microsoft and even they didn't know the answer!

  5. #5
    Join Date
    Jan 2003
    Location
    Aberdeen, Scotland, UK
    Posts
    168
    Could you create a new Query with all 3 of these Queries in it?

  6. #6
    Join Date
    Mar 2003
    Posts
    5

    Unhappy

    Tried that too! Two of the queries will pull up several records for each project and so these can't be merged into one query...

  7. #7
    Join Date
    Mar 2003
    Posts
    5
    Originally posted by saross
    Tried that too! Two of the queries will pull up several records for each project and so these can't be merged into one query...
    Ok, done it!! You can use Visual Basic within Word to write macros that open and query databases in Access for you using SQL statements. By placing bookmarks on the word document you can format the outputted data.

Posting Permissions

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