How can I create an email that will keep an attachment which is stored in a record/query?

[NaomiC]

Hello,



I have a database that I'm using to to track resumes. Each record will have the individuals contact information, position they are qualified for and location preference details along with an attachment field for a resume or other documents. There may be 1 or more attachments per record.

In my database I have certain queries set up for each position and one query that allows me to type the position title to return all those records.

What I would like to accomplish is a way to send an email to a hiring manager that will have a listing of all the qualified individuals and their corresponding resumes attached to the email. (Most of the attachments are saved as a PDF.)

Another thing is the documents will need to be password protected. (The same password can be applied to all documents.)

The hiring manager's email addresses are not part of my database so I will need the TO: line to be blank.

Does anyone have any suggestions/solutions as to how I may accomplish this task? My knowlege of Access is limited and I have self-taught anything I do know, which isn't much so simplest terms and detailed explanations are appreciated.

Thank you,

Naomi

[June7]

Fairly common topic. The file to be attached to email must be external from the db.

Cannot use SendObject method.

Review https://www.accessforums.net/program...ook-21903.html