Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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!

share|improve this question

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). Mail merge starting position

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

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

Pick the Excel file. Insert your fields. Adding the mail merge fields

Select "Finish and Merge", "Edit Individual Documents..." Select 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. Mail merge separated into each specific page

share|improve this answer
So I would manually copy and paste each page. 700 pages... And I would have to do this any time the form changes? – Bil1 May 13 '14 at 14:53
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 May 13 '14 at 16:57
Yes. That is what I thought the solution might be. I am a programmer but VB isn't a specialty of mine. – Bil1 May 14 '14 at 14:12
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 May 14 '14 at 14:18
@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 May 16 '14 at 17:57

There is an add-in for splitting a merge, then a macro you could use for the password... for the add-in then for the password macro...

share|improve this answer
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. – Wes Sayeed Sep 25 '14 at 23:05

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.