Emailing Image Attachments from Access This sample illustrates how to use Outlook Automation to send an email with an image attachement from Access.
DBPix Image Control version 2.0.
Microsoft Access 2000 or later.
Outlook 2000 or Later.
Unzip the archive into a new/empty folder.
Open the form "frmImages".
Click the button "Send Email".
When Outlook opens complete the "To:" field.
The email is ready to send.
This sample uses some simple Outlook automation commands to create an email. The image (which is stored in the database in this example) is saved to a temporary file, then attached to the message. Finally the message is displayed to the user for review.
Note that the To address could be completed automatically, and the email sent without user intervention, so a fully automated emailing mechanism is possible if required.
Files & Code
|File / module|| ||Description|| || |
|frmImages|| ||Code to launch Outlook and create an email with an attached image from the database.|| ||View Code|