Excel macro for mail merge and password protected pdf

[shaikhstonevilla]

Hi,

Thank you for reading this post.

I need your help. I have some data an excel.. let's say column A has clients name and column B has clients email address.

Column C sales figures.

What I want is that I want to use excel macro so that

1) I can send email to each clients individually.
2) Macro should create password protected pdf file where password should be same "google12" for each clients for pdf file. Pdf file should have sales figure for particular clients.

Thank you for your help and support.

Kind regards,
shaikhstonevilla