Email Sheets to various contacts in PDF and also excel (but locked)

I'm asking for a friend, I'm helping to work on a spreadsheet with multiple sheets , that will then be emailed once a month, with different sheets going to different contacts.
because of our timezone difference, i may be slow to reply, so apologies in advance, BUT I will reply.

If a sheet could be used to maintain a list of contacts and which sheet to email out
Also in which format PDF, Excel (locked down) or both
would be useful.

A button maybe on the contact sheet to start the process / but also with an option to set-up to email on a certain day per month would be good

the number of contacts at the moment varies between 1 and 4 for each sheet - perhaps , we could set-up to email up to 10 contacts per sheet

The email client is Outlook

Each contact should only receive their sheet and not see any of the other sheets , also the contacts should not be able to alter the spreadsheet at all. hence the possibility of using PDF , but most still would like to see the report in excel format.

there would be about 20 sheets , to go to between 1 and 10 contacts for each sheet

I have attached a dummy workbook , which has 4 example worksheets in

In the real workbook, the worksheet names , also will have spaces in them.

I could setup a Start Sheet and a finish sheet - so that the macro - can go through each worksheet in between , if that offers a solution
also a maintenance sheet which has the sheet name , email contacts email address and PDF, Excel or both format.

my knowledge of VBA is very rusty, as its was a few years ago I played with macros in any depth.

i have outlook on my PC , so i can play - BUT its not connected via exchange server, if that makes any difference

thanks for any help

please ask for any further clarification , and I will do my best to provide any information required.

bump, anyone?

i managed to get quite a lot of the VBA code written using Ron de Bruin, link http://msdn.microsoft.com/en-us/library/bb268022.aspx

in case anyone reads and wants to see the solution