0
I have created the perfect form for time sheets at work. My goal was to mail merge the pages with personnel data. Then protect the document with a password so people don't accidentally change the form. Then e-mail each individual page to the employees.
Is there a good way to go about doing this? I can't mail merge a protected document. I can't figure out how to split it by pages.
Thanks for any and all help!
So I would manually copy and paste each page. 700 pages... And I would have to do this any time the form changes? – Bil1 – 2014-05-13T14:53:14.897
Perhaps a VBA macro would do this for you-- separate the document and perhaps even tie in with Outlook to automate the email process. Are you interested in such a solution? – bgStack15 – 2014-05-13T16:57:41.400
Yes. That is what I thought the solution might be. I am a programmer but VB isn't a specialty of mine. – Bil1 – 2014-05-14T14:12:44.700
Ah, VB is not VBA. It's not a big deal that it's not your specialty--frankly it wasn't the best programming language ever invented. I'll start working on a solution for you. – bgStack15 – 2014-05-14T14:18:29.253
@Bil1, sorry, I'm not able to continue working on this at this time. It's harder than I thought and other things came up. – bgStack15 – 2014-05-16T17:57:56.933