Mail Merge, Split, Protect, and E-mail Word 2013 Document

Question

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!

Mail Merge narrative:

Use a data source (I'm using Excel). Use the Word doc (I'm starting with a generic, run-of-the-mill Word doc).

Select MAILINGS tab, "Start Mail Merge", Letters.

Select "Select recipients", Use an Existing List...

Pick the Excel file. Insert your fields.

Select "Finish and Merge", "Edit Individual Documents..."

A new document is made with a page per person. Separate the pages (copy/paste a whole page to a new doc), protect, save, and send.

Comments

[Bil1]

So I would manually copy and paste each page. 700 pages... And I would have to do this any time the form changes?

[Bil1]

Yes. That is what I thought the solution might be. I am a programmer but VB isn't a specialty of mine.

[bgStack15]

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]

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

[Wes Sayeed]

The second link just points to another web forum. Please include the relevant information in your post, as it's unclear which posting in that forum is the correct answer.