Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-17-2014, 04:21 PM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline Creating a customizable letter template Windows 7 64bit Creating a customizable letter template Office 2013
Moderator
 
Join Date: Aug 2011
Posts: 4,049
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default


You could set up a letterhead template. See http://wordfaqs.mvps.org/LetterheadRibbon.htm.
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #2  
Old 03-17-2014, 04:25 PM
BarbaraW BarbaraW is offline Creating a customizable letter template Windows 7 32bit Creating a customizable letter template Office 2010 32bit
Novice
Creating a customizable letter template
 
Join Date: Mar 2014
Posts: 3
BarbaraW is on a distinguished road
Default

Thank you Stefan, my research has led me towards creating templates and Userforms to collect the personalized info. This sounds similar to what you are recommending.

Barbara
Reply With Quote
  #3  
Old 03-18-2014, 04:49 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline Creating a customizable letter template Windows 7 64bit Creating a customizable letter template Office 2013
Moderator
 
Join Date: Aug 2011
Posts: 4,049
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

UserForms will be a bit more "advanced" than what I had in mind. :-)
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #4  
Old 03-18-2014, 08:35 AM
BarbaraW BarbaraW is offline Creating a customizable letter template Windows 7 32bit Creating a customizable letter template Office 2010 32bit
Novice
Creating a customizable letter template
 
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
Reply

Tags
automation, letters, templates



Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a customizable letter template Creating Customizable checklist gmc2k2 Office 1 08-09-2011 09:26 AM
Creating document from template but macros are still linked to template webharvest Word 0 07-16-2011 09:34 AM
Letter Head Template - Update all other templates automatically nirok Word 1 11-25-2010 03:14 PM
Creating a customizable letter template create letter template with fixed position fields and follow up pages Lynn O'Shea Word 3 05-18-2010 12:32 AM
Word Letter Template Issue Swarv Word 1 02-19-2010 08:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:10 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft