View Single Post
 
Old 03-18-2014, 08:35 AM
BarbaraW BarbaraW is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Mar 2014
Posts: 3
BarbaraW is on a distinguished road
Talking Creating a customizable letter template

Thanks for all the Charles and Stefan! I'm already gaining an understanding of some of the different approaches. Maybe if I explain what I'm trying to accomplish more specifically you can help me find a good approach.

I have about twelve different letters -- all include letterhead and have the same page layout and formatting. The content of the letters are different. Each letter has about 8-10 fields for unique recipient information (names, addresses, dates, license numbers, etc.). I will also need to share the completed templates across my work team of five people. Usually only one or two of the same template are created for different recipients during a work session but the user may be generating 15-20 letters using different templates and different unique recipient information. For example, we may send Letter One to Clients A and C, Letter Two to Client Z, and Letter Five to Clients E and F. Would a mail merge be practical for that need?

The two problems I am trying to solve are that it is not very efficient to cut and paste. Over the course of a month my team sends out several hundred letters so this inefficiency is really multiplied, error-proofing the letters is an issue also.

So far my research indicates that I could create a template for Letter One.dot that would have bookmarks for the unique recipient information, embed a macro that would open a UserForm that would collect the unique recipient information and merge it into the letter. Am I making it too complicated?

Thanks again for the helpful suggestions, I'm looking forward to your further thoughts and ideas.
Barbara
Reply With Quote