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.
Bookmarks