I would like to perform the following process for 100 individual users on a regular basis:

1. Create word document with imported data unique for each user
2. Automatically password protect each user's document with his unique password or do the same with a pdf of the document
3. Use Outlook to automatically email the password protected document to each unique user

This is similar to password protected pdf account statements, etc., that are often emailed by insurance companies to individuals, etc.

I would like to pull the password from Excel or Access and somehow have Outlook or another application apply the appropriate email address and send the pdf or doc to the appropriate individual.

I know how to perform #1 using mail merge but i'm stumped on #2 and #3.

Thanks for any help or suggestions.