Hello
I have an excel document with 50 names of employees (1 name = 1 row) and with 365 columns (1 column = 1 day, tells which workshift to do).
We would like to send each employee his annual planning without everyone to see the planning of his colleagues + the possibility to give remarks about which work shifts they want to change (f.e. 'date x/week x I want a late shift, not an early one, ..')
Worst case scenario is to use the 'mail merge' from Word en create 50 seperate documents that we can e-mail to the employees (= their personal annual planning), but that seems a lots of work …
Does anyone have an idea which software program we could use? I was thinking about Office Forms and Google Forms but the options are rather limited (you can't select a date f.e.)
Is there a possibility to split the excel automatically per row and create separate documents automatically? So we can e-mail the planning to each employee? Still a lot of work though...
I hope my question isn't too vague English is nog my mother language but I did my best
Thank you.
Bookmarks