Email Attachments - From a Directory of Files

[robboll]

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

 

[Daniel Pineault]

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=en&id=0000000013#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=en&id=0000000027#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.