Results 1 to 2 of 2
  1. #1
    arnoderuig is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jul 2015

    Qualitydifference pdf-document DoCmd.OutputTo Docmd.Sendobject

    In my Access2010-application I use a VBA-script that automatically does place a report as pdf-file on disc. This script reads as follow (shortened):

    DoCmd.OutputTo acOutputReport, reportname, acFormatPDF, filename&place

    Later I have written an script that the same report does attach a pdf-file to an email. This script reads as follows (shortened):

    DoCmd.SendObject acSendReport, reportname, acFormatPDF, mailaddress, , , , , Yes

    In the original report a picture is used as wallpaper; this image contains the name, address and bankdetails of my customer. It now appears that both pdf files have a different quality. The file that the lower quality supplies is the file as an attachment to the email. That difference is noticeable to the image as out of focus is that for example the bank data is not easy to read.

    Who knows how this difference can arise. Is there for example somewhere within Access stuck in what quality a pdf file is created?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    I don't think there is any way to control this. Alternative is to use Outlook automation and attach the external saved PDF instead of SendObject.
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 15
    Last Post: 06-29-2015, 11:12 AM
  2. Docmd.outputto Error
    By DaveWatson in forum Programming
    Replies: 5
    Last Post: 11-05-2012, 05:55 PM
  3. DoCmd.OutputTo acOutputReport
    By GraeagleBill in forum Reports
    Replies: 11
    Last Post: 09-15-2012, 07:33 PM
  4. DoCmd.OutputTo
    By tylerg11 in forum Reports
    Replies: 2
    Last Post: 08-09-2012, 12:22 PM
  5. AcFormat in DoCmd.OutputTo
    By SIGMA248 in forum Programming
    Replies: 1
    Last Post: 04-15-2011, 08:50 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