Results 1 to 10 of 10
  1. #1
    Join Date
    Aug 2018
    Posts
    9

    Screenshot

    My supervisor wants me to not only send my form as a PDF via email, but also attach it as a image... Can someone point me into the right direction if this is possible and if so, how to go about doing it?



    THANKS SO MUCH

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    A PDF is an image. So what do you mean by 'image' - jpg, png, bmp? Have you web searched topic?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Join Date
    Aug 2018
    Posts
    9
    -jpg, png, bmp, etc... I have googled the topic and I have come across somethings but nothing has worked so far.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Best may be able to do directly with Access is a report to EMF or WMF file type. Review http://www.lebans.com/ReportUtilities.htm
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    First of all forms are not intended to be 'printed'. If you need to export as a PDF or image. Create a report based on your form.
    You can save the report as a PDF easily from the ribbon.
    I see no purpose in creating a separate screenshot but if that's required there are various utilities that can capture the screen as an image which could be attached to your email. For example, see https://www.access-programmers.co.uk...d.php?t=306917
    Last edited by isladogs; 11-08-2019 at 05:06 PM.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  6. #6
    Join Date
    Aug 2018
    Posts
    9
    That was a miswording on my part. A screenshot of a report is what is asked. I have a pdf copy being sent out already, and for some reason they want an "image" of it too..

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    And what code do you use to send this PDF? Attaching another image file to email will require Outlook automation.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    If you use CDO to send email, you can do this entirely without Outlook.
    In fact you don't even need Outlook installed
    The captured screenshot image can be sent as an attachment or if you use HTML email, embedded in the email body
    The PDF would of course be an attachment if both need to be sent.

    This CDO EMail Tester example app may be helpful to get you started http://www.mendipdatasystems.co.uk/e...ter/4594365455
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  9. #9
    Join Date
    Aug 2018
    Posts
    9
    Here is the code I use to send the report
    Code:
    DoCmd.SendObject acSendReport, "REPORT NAME", "PDFFormat(*.pdf)", EMAILS,"","","SUBJECT","EMAIL BODY", True, ""

  10. #10
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Try
    DoCmd.SendObject acSendReport, "reportname", acFormatPDF, .......
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Replies: 5
    Last Post: 10-22-2016, 09:29 AM
  2. Replies: 3
    Last Post: 05-18-2015, 11:24 AM
  3. Replies: 6
    Last Post: 05-24-2012, 11:07 AM
  4. Replies: 1
    Last Post: 01-26-2012, 05:25 PM
  5. Date not Sorting Correctly (screenshot attached)
    By KrenzyRyan in forum Queries
    Replies: 5
    Last Post: 06-27-2011, 01:44 PM

Tags for this Thread

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