How do you put a password on a generated report that gets emailed that is in the .rtf format. so that everytime a report is generated from a query by a command button and using the send object to email this .rtf report. i want it to be password protected..
do you want the recipient to have to enter a password to view the report once they receive it (difficult) or do you want the operator emailing out the report to enter a password before they are able to (easy)?
Hi Jessy - why send the report if the recipient may not acutally be able to open it? Why not keep a central store of potential recipients and their permissions to respective reports? Only send to those with the requisite permissions. Otherwise - you send a report to someone, they don't have the password, they call you, you say they aren't permitted to view the report and they ask why then did you send it in the first place?