Results 1 to 6 of 6
  1. #1
    Join Date
    May 2006
    Location
    NYC
    Posts
    30

    Unanswered: Send Object using A PDF

    Greetings Everyone,

    Everyday I will print my Access reports into a PDF format and send it to people. I like to automate this and send it via email but I'm not sure if I can solely do this in Access alone. If someone tells me I have to use some other Office Automation watchamacallit program,... I might be in trouble ,...

    My report is pretty big and fits only on 11 by 17 paper. I tried the RTF route but it didn't look as nice.

    Can Access send a PDF once it is created is my first question?

    The other question is if I can't send it using a PDF format via Access is there a way to at least automate it to print my reports in PDF formats? This will help cut some printing time. I've been playing around with the Macros but wasn't able to print it to PDFs.

    Any guidance/direction will be much appreciated!

    Thanks & Cheers!!

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,423
    Provided Answers: 8
    Yes and No

    this is a mod one of my bosses has ask for.


    They Have deskpdf (standard) which create the pdf

    I see there is a option in to Email the pdf as attachments.


    This is line of thinking


    Create a hidden feild on the said form with the email address in it

    When they Click the buttom to Print the Pdf it will paste the email address into the clip board
    with the code from

    http://www.mvps.org/access/api/api0049.htm

    Then then the mail box open with the attachment attach click in the to and do a ctrl + v to paste the email address in.


    what do think that idea


    has some else got a beater idea.
    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.

  3. #3
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Do you have Adobe Acrobat loaded on your machine? If so, all you need to do is print to the Acrobat Distiller (it should be one of your printers). That converts it to a PDF, it prompts you for a filename and then converts it.

    In Access you can use Page Setup to tell it to print to Acrobat Distiller automatically. Choose File/Page Setup when you are designing a report. Then choose the Page tab and then select Use Specific Printer and hit the Printer button. Choose Adobe Acrobat and it will default to printing to that 'printer'.

    As far as mailing it, if you only have one recipient (not sure on the limitations) and one attachment you can use SendObject. Otherwise you have to use something a little more flexible like CDO.

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,423
    Provided Answers: 8
    DCKunkle

    Yeap

    but the only problem with the SendObject Is Getting The PDF made

    can't find any thing or write anything That does the Create PDF with no hands


    There was one for the old older version pdf
    @ http://www.mvps.org
    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.

  5. #5
    Join Date
    May 2006
    Location
    NYC
    Posts
    30
    Ok, Let me try the suggestions and I will let you know how I do.

    Myles, I ventured to your link with the API and saw the lines of code. My eyes are still spinning trying to understand it. But I'm going to try it! ;-0

    Thanks and Stay tuned!

  6. #6
    Join Date
    Jun 2010
    Posts
    9
    Here's a document that describes some of the features and limitations of the SendObject command in Microsoft Access.

    Access 2007 and 2010 can generate PDF files directly from Access.

Posting Permissions

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