i have an form to send email in access 2000. i am trying to populate a combo box with the reports in the database and and use it to send them as attachements. the problem is that i think the combo box is just displaying the name of the report and not referencing the report itself. if that makes sense? this is the code for the rowsource of the combo box:
SELECT MsysObjects.Name
FROM MsysObjects
WHERE (((MsysObjects.Type)=-32764))
ORDER BY MsysObjects.Name;
i can attach files off the hard drive with GetOpenFile but i can't seem to attach a database report.
also, i am NOT using the sendobject method to send the emails, so DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile] won't help any.
any help someone can give me with this would be very appreciated.
jerry.
SELECT MsysObjects.Name
FROM MsysObjects
WHERE (((MsysObjects.Type)=-32764))
ORDER BY MsysObjects.Name;
i can attach files off the hard drive with GetOpenFile but i can't seem to attach a database report.
also, i am NOT using the sendobject method to send the emails, so DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile] won't help any.
any help someone can give me with this would be very appreciated.
jerry.