Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-11-2013, 08:30 AM
gvibe@hotmail.com gvibe@hotmail.com is offline Form Letters and checklists Windows XP Form Letters and checklists Office 2007
Novice
Form Letters and checklists
 
Join Date: Jul 2013
Posts: 4
gvibe@hotmail.com is on a distinguished road
Default Form Letters and checklists

Hi,
We have form letters that are sent out from our dept. for code violations. Most of the letter is standard language, but we have a long list of violations and each letter may reference any number of them. I'd like to set it up so that we can just select the applicable citations via a checklist or pulldown etc and have the body of the letter only show those items. I'd also like the other parts of the letter to space accordingly so that we don't have large gaps for letters that only have a single citation.

Is there a way to do this?

Thanks
Brian


XP, Word 2007
Reply With Quote
  #2  
Old 07-11-2013, 11:14 AM
Charles Kenyon Charles Kenyon is offline Form Letters and checklists Windows Vista Form Letters and checklists Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,463
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

There are a number of ways to do this. The most elegant method would be to use a Userform that would gather address information and could have a checklist of code violations that could be checked off. When the person using the form was finished checking off the violations they would click the OK button and the letter would be constructed, putting the language you want in an appropriate place in the letter. This requires VBA (macros).
Reply With Quote
  #3  
Old 07-11-2013, 03:09 PM
gvibe@hotmail.com gvibe@hotmail.com is offline Form Letters and checklists Windows XP Form Letters and checklists Office 2007
Novice
Form Letters and checklists
 
Join Date: Jul 2013
Posts: 4
gvibe@hotmail.com is on a distinguished road
Default

Thanks Charles,
The letters are being generated from our code enforcement software. Basically we set up word templates which the software populates with info from the database record. The letters open as Word documents so I was hoping that I could alter the initial form in some way, since doing this within the code software will be cumbersome and require a whole bunch of expensive involvement of their tech support folks.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Form Letters and checklists Letters Cut Berne Word 1 05-31-2012 02:29 PM
letters are dashes pmd Word 5 03-05-2012 08:08 PM
My letters disappear come rain or shine Word 2 10-11-2011 02:18 PM
Form Letters and checklists Creating TOC with letters and numbers tanababa Word 1 04-28-2011 01:35 AM
Form Letters and checklists sending personal letters misteroffice Word 3 12-23-2008 08:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:49 AM.


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