Results 1 to 6 of 6
  1. #1
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    I have an access report that I send as an email attachment in rtf format from an access form.
    However, I would prefer to send the report as a pdf.
    I am after being able to create a named pdf file from the access report, and then use this as the attachment instead.
    Can anyone tell me how to create a pdf from the access report.
    I suspect that I would need to print it to the pdf driver.
    Just need to know how to do that and name the file and location.
    OR even better if there is a way to talk directly to adobe
    .
    Andrew

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    [quote name='AndrewKKWalker' post='783283' date='07-Jul-2009 10:45']I have an access report that I send as an email attachment in rtf format from an access form.
    However, I would prefer to send the report as a pdf.
    I am after being able to create a named pdf file from the access report, and then use this as the attachment instead.
    Can anyone tell me how to create a pdf from the access report.
    I suspect that I would need to print it to the pdf driver.
    Just need to know how to do that and name the file and location.
    OR even better if there is a way to talk directly to adobe
    .[/quote]
    Do search on SendMail on this forum and you will find examples that firstly create the pdf (defined as a printer) then the SendMail routine that sends the attachment.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can print to the Adobe PDF printer, or you can use Stephen Lebans' free ReportToPDF to convert a report to a PDF file using VBA.
    Then search for SendMail, as mentioned by Patt, for code that sends mail with an attachment.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Adding my 2 cents, if you are using Access 2007 with Service Pack 2, it is almost trivial, as the export to PDF is now a built in feature.
    Wendell

  5. #5
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    [quote name='HansV' post='783302' date='07-Jul-2009 06:31']You can print to the Adobe PDF printer, or you can use Stephen Lebans' free ReportToPDF to convert a report to a PDF file using VBA.
    Then search for SendMail, as mentioned by Patt, for code that sends mail with an attachment.[/quote]

    Just checked it out.

    Excellent!

    Job Done.

    Thanks Hans
    Andrew

  6. #6
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    [quote name='WendellB' post='783354' date='07-Jul-2009 15:44']Adding my 2 cents, if you are using Access 2007 with Service Pack 2, it is almost trivial, as the export to PDF is now a built in feature.[/quote]

    Unfortunately Wendell at the moment Office 2007 is not an option
    Andrew

Posting Permissions

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