Emailing reports as attachments from microsoft access 2007

Many types of files can be stored in a column which has the attachment data type. Someone can add bitmap files, jpg files, sound files, word documents, etc. However, these objects will be run by the appropriate executable programs for these attachments when they are called to do so. This goes even further such that you can attach multiple, different types of attachments to the same record. This allows for the storage of the information about an employee including his picture, his resume, and any other necessary information all in one column.

The Access project which is now supported again in Access does not support the attachment data type since the underlying database does not. This comprehensive tutorial shows an example of creating a table with a column which has the new data type, attachments. It also shows how you may populate the table and view the contents of the table. It goes further and shows you how to create a report based on this table and how the report can be viewed effectively to display or render its contents. If I have three attachments, like in this article, it creates three instances of the same information.

Title: Saving Attachment links to a separate field as a hyperlink Name: Michael Bailey Date: AM Comment: Is it possible to save the link data for an attachment to a separate field as a hyperlink? OpenRecordset "picsTable" If rs. Fields "picsFormFieldName". Value While Not rsPics. EOF rsPics. Delete rsPics. MoveNext Wend rs. Update End If rs. Remove From My Forums. Asked by:. Archived Forums. Access for Developers. Sign in to vote. Hi All, Is there a way to attach files to an Outlook email in VBA from an Attachment field in Access without having to write the file out to the hard drive?

MoveNext Loop The code fails on the line objMail. Tuesday, September 27, PM. Hi, I'm not sure it is possible. Application, oMailItem As Outlook. MailItem, oAttachment As Outlook.

Item 1. Recordset, rsAttachements As dao. Fields fName. Fields "FileData". Value End Function. Andrey, Thanks for your response. Thank you, Chris Chris Galla. Yet another option is PDF. Access and newer can create PDF files directly. Lebans solution no longer works in Access as the ability to create snapshot files has been removed which Lebans utility requires.

Auto FE Updater distribute new and updated Front End databases to your users with several mouse clicks. Granite Fleet Manager - the best designed fleet maintenance tracking and management system available. Comments email Tony. Tony's Blog. Privacy Policy.