Link from Forms to Outlook email with attachment of current records' image

[dreamzdestiny]

I have a form where the user selects a part number, the corresponding information is populated in the two separate sub forms and the picture of that part comes in another small window which is called by a 3rd sub form.
I need to be able to have a button on this form, when the user clicks on this it should open up a new email in outlook with the current image attached automatically to that email. The TO fields, CC fields SUB fields and the body can all be filled in by the user, but the image is the only thing that needs to be automatically added to the new mail message. The only reason being the user does not have access to image file directly and we do not want them to know the path of the directory as well.
this is a front end database loaded in all the individual computers with the backend in the network drive
I've tried plenty of threads and posts with no success. I tried referencing the Outlook Library, but some codes do not seem to work at all.
Any help in this would be greatly regarded.
Thank you

 

[ted.martin]

Search this site using the phrase "email with attachment"

There are 2 or 3 ways to do this; select the most appropriate for your needs.