Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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 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? –  bgStack May 13 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 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. –  bgStack May 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. –  bgStack May 16 at 17:57

Your Answer

 
discard

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.