Results 1 to 2 of 2
  1. #1
    AccessSLC is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Oct 2017
    Posts
    1

    How to included attached files to a report

    Hi, thank you for your help in advance! I have created a table, and one of the fields in the table allows me to attach PDFs. I am able to view the attached PDF in the Forms and Reports I created. But I would like to send a report I have created as a PDF, along with the all the attached PDFs. Is there a way to do this? Thanks!

  2. #2
    Bulzie is online now VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    There is alot of threds online about sending attachments in MS Access so research those. Below is some code to review, might work for you. Also look at the SendObject method.

    Dim strFile As String
    strFile = "C:\TestPDF\InvoiceReport_" & Format(Now, "YYYYMMDD_hms") & ".pdf"
    DoCmd.OutputTo acOutputReport, "rptInvoice", acFormatPDF, strFile

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 11-07-2013, 12:17 PM
  2. Totals for records not included in report
    By hilian in forum Reports
    Replies: 16
    Last Post: 06-18-2012, 07:47 PM
  3. Attached Files
    By tcheck in forum Access
    Replies: 1
    Last Post: 08-11-2011, 09:46 PM
  4. Where are attached files stored?
    By Delta223 in forum Access
    Replies: 3
    Last Post: 01-11-2011, 10:32 AM
  5. Replies: 1
    Last Post: 07-09-2006, 09:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums