OLE Object Links

[magmike]

IN creating an email through an Access form, and wanting to also add
an attachment, I am trying to generate the link to the document.

If I were only using one document, or a report from within Access,
this wouldn't be an issue (as I could just code in the link), but I am
dealing with a self created document server from within my access
database. There are multiple documents that could be selected through
a combo box on the email form. All the documents are stored outside of
Access, and Access stores the link in the table. This is done when the
OLE Object field is used on the Documents Form (when documents are
stored), but the user selects the "link" option instead of embedding
the file in the database.

When I view the table of documents, however, the field value shows,
"Adobe Acrobat Document" or "Microsoft Excel Document" and so on
instead of the link. When I code in [ItemLink] in the email forms
code, it is not working, so it is evident that the path is not being
used in the field as text. Is there a way to automatically store the
path as text to a second field in the document table when adding
documents through the OLE Object field that I could then use in my
email form?

Thanks in advance!
magmike