Results 1 to 1 of 1
2013-04-05, 14:14 #1
- Join Date
- Dec 2009
- Thanked 1 Time in 1 Post
Automatically apply user specific password to doc or pdf for email
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.