View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sai Krishna[_2_] Sai Krishna[_2_] is offline
external usenet poster
 
Posts: 29
Default Excel information in PDF with a password

Hi friends,

at times I may need to send mass mails which could be confidential in nature.

For example, I may need to send pay hike letters to A,BC,D and E with
different salaries, the letter format being the same.

Now, normally I could use the regular mail merge facility between word and
excel and send the letters as a word attachment. (using merge to email).
This could be opened by anybody. Thus an unauthorized person may get to see
the contents of the letter.

Can I do the following?

1. Mail merge into a PDF doc? This is basically to make it difficult to
alter the contents, if not impossible.
2. Have a password for each recipient which only the recipient knows?

Is this possible?
Regards
Krishna