email document

  • Thread starter Thread starter Lodewijk Olthof
  • Start date Start date
L

Lodewijk Olthof

How can i email a document form disk through access?

On a form I have the field txtFileName which contains the name of a document
(e.g. C:\Documents\2003\2003029.doc). Now I want to create a button that
sends that file to an email adress (in txtEmailAdress).
 
There are some inexpensive third party products that integrate well with
Access and can do this. The one I really like and have used for the last
couple of years is located at:

http://ourworld.compuserve.com/homepages/attac-cg/

See the PDF and Mail Class Library. The PDF portion of this is also very
good if you need to create PDF documents from within Access. I combined the
two, allowing my users to merge multiple Access reports, Word documents and
Excel spreadsheets into one common PDF document with bookmarks, then send it
as an email through Outlook.

Bill
 
I guess there should be an easier way. I tried the Sendobject, but then it
is not possible to send a document from disc.
 
Back
Top