If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Email Attachments - From a Directory of Files
Hello! I am looking for an email routine using Microsoft Access where
there is an option to include associated PDF or Word documents from the working (Windows) directory. So any PDF file or DOCs put in the external directory are automatically attached to the email. The user naturally has the option of deleting any unwanted attachments. This is a poor idea in general, but in this situation the application creates a windows directory based on a key column of the parent table, and the user can put associated documents in that directory -- a small number of relevant documents. Another approach might be to actually open the documents directory, hold down shift, and "select" the files to be attached. But I think that keeping it simple is best. Appreciate any help with this! RBollinger |
#2
|
|||
|
|||
Email Attachments - From a Directory of Files
for your situation you'll need to automate Outlook and add the attachments.
The link below give a simple function to do this http://www.devhut.net/index.php?lang...000013#AutoOlk Set the bEdit variable to true then the user can review the attached documents as they please. You could build an array of the files ( see http://www.devhut.net/index.php?lang...000027#DirList ) to be included as attachments and pass it to the function. Your situation is a little unique, but the basic building block are readily available. -- Hope this helps, Daniel Pineault For Access Tips and Examples: http://www.devhut.com/index.php If this post was helpful, please rate it by using the vote buttons. "robboll" wrote: Hello! I am looking for an email routine using Microsoft Access where there is an option to include associated PDF or Word documents from the working (Windows) directory. So any PDF file or DOCs put in the external directory are automatically attached to the email. The user naturally has the option of deleting any unwanted attachments. This is a poor idea in general, but in this situation the application creates a windows directory based on a key column of the parent table, and the user can put associated documents in that directory -- a small number of relevant documents. Another approach might be to actually open the documents directory, hold down shift, and "select" the files to be attached. But I think that keeping it simple is best. Appreciate any help with this! RBollinger |
Thread Tools | |
Display Modes | |
|
|