Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Posts
    115

    Unanswered: Combine report to attached PDF

    I have a pdf file linked to my record (C:\mypdf\abc.pdf)
    I would like to email the pdf from access. However, I would like my report to be part of the PDF (at the beginning of the PDF). Is this possible?
    If its needed to get a specific PDF version, Im ok with that.

    Thank you

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you will not be sble to do this from within Access. the best option may be to use a tool such as FoxyUtils MergePDF - Merge PDF Files Online for Free to merge two pre-existing PDF's
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,423
    Provided Answers: 8
    There is a work around I do it for invoices the user has a copy of adobe PDF on the computer

    First u need some Code to find the mydoc folder
    Then find some code to change the default printer just in case they want to print a hard copy

    So when the user prints the invoice the code changes the default printer to the PDF writer
    A message box popup and tells the user to save it to the mydocument folder just click save "the file name is the caption name of the documents" then and the tick is when the user closes the report I have code that check the mydoc folder for a PDF file called the caption name iF NO PDF CALL THE CAPTION NAME THEM THE PDF WAS NOT CREATED it tell the user and reopen the report for them to try again if the file is there them it rename to the invoice number + customer name.pdf and moves to the invoice folder and change the default printer back to what was back.

    This is my way of sorting out the PDF thing I have tried a heaps of other ways and this is the best option I found ie
    Changing the default printer
    Checking has the user created the PDF <= was the hard bit to sort until I found the mydoc code to find that path
    Rename the PDF to a logical name
    And it had to all by code


    Sorry a bit off track

    why just attach the PDF to the header of the report insert it as a object
    (this is the way I full out forms that are in a PDF format insert the PDF as and float the fields over top of the report)

    As for emailing user
    what I is send via smtp not use outlook as of all the security u have to pass though and just bcc the sender and it in there outlook to

    As u know where the PDF is in the my doc folder u can attach it. Done
    Last edited by myle; 09-04-13 at 07:26. Reason: Spelling
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  4. #4
    Join Date
    Jan 2004
    Posts
    115
    Im not sure that I understand correctly. Is your solution combining your report together with the existing PDF (and makes it as 1 PDF)?
    Thats what I would like to do.

    Regarding your second point, the original PDS file is over 100 pages, does it make sense to inter it as an object?
    My report is 1 page and I would like to combine it as 1 PDS with the original PDF.
    Thanks

  5. #5
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,423
    Provided Answers: 8
    100 pages don't think u be able to do it that way that a big file

    Not at the computer thinking off top of head

    What about using the sendkey to open the PDF in adobe and then insert a said page
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  6. #6
    Join Date
    Jan 2004
    Posts
    115
    how do you insert a page into the PDF?

Posting Permissions

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