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
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
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.
-jpg, png, bmp, etc... I have googled the topic and I have come across somethings but nothing has worked so far.
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.
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.
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..
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.
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
Here is the code I use to send the report
Code:DoCmd.SendObject acSendReport, "REPORT NAME", "PDFFormat(*.pdf)", EMAILS,"","","SUBJECT","EMAIL BODY", True, ""