Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006
    Posts
    7

    Unanswered: Tricky w/ Excel Templates

    I want to export filtered records from a query to an excel template showing common information in the header and calculated sums, etc. in the footer. I want to attach the resulting spreadsheet to a ready-to-send email complete with recipients, subject, and message. And I want to allow the user to do it by clicking a button.

    This is easily done by exporting a report to an email in an html attachment, but the data is hard to manipulate once received, and page breaks are prohibiting.

    (1)

    Is it possible to create a DAO.Recordset, and then use OutputTo (acOutputQuery) to export an xls? How then can the xls be attached to an email?

    (2)

    Is there a thread that explains how to create smart templates in Excel? How do you set up rows to capture repeating line items like in Access reporting? Can you aggregate data?

    Thanks for any help... I'm lost.

    Matt

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    I usually use a method similar to Pootle's code to export the data to a spreadsheet, this approach let's you do pretty much anything with the workbook that you would otherwise be able to do. Check out this site for email info.
    Me.Geek = True

  3. #3
    Join Date
    Dec 2006
    Posts
    7
    Gracias!!!

Posting Permissions

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