Question Email hyperlinked document - is it possible?

[humph]

I am really not sure if this can be done but hopefully someone will point me in the right direction if it can.

I have a contacts database for an accountant with hyperlinks to numerous documents all set up and they work correctly - open the application and show document.

What I would really like to do is from within Access using VBA send an email to the client enclosing the hyperlinked document ( not the hyperlink itself which would not be avaialble to the client).

Simple question is this possible any help appreciated. :banghead::banghead::banghead:

 

[pbaldy]

You can automate Outlook and add an attachment if you know the path. I don't use the hyperlink data type, so I'm not sure if it can be used though. I seem to remember that it stores more than just a path. I just use a text field to store the path and use code to open the document. This might help you get started:

http://support.microsoft.com/?kbid=161088