Create a Form Letter?

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I have created a form letter using a report. It works fine if I set
everything up in the design view no problem. What I want to do is to
set it up so the body of the form letter can be changed without going
into design view by staff so they can change the letter.

I created an unbound form and put a unbound text field in the unbound
form and was hoping that I could use this by putting an unbound text
field in the Form Letter and having its properties associated with the
unbound text field in the unbound form. But what happens is I get a
?Name error.

Can I set up my changable form letter like this or do I need to do it
another way? Or what do I need to do to fix this?
 
If you wnat your users to maintain 'stuff' on the letter, I would create a
table and have fields such as, IntroductoryParagraph, SecondaryParagraph,
ConcludingParagraph, Closing, etc.

Then build them a form and let them modify the fields.

Use these fields in your letter.

NOTE: Do not allow the form to ADD records to the table, only to edit. You
should only have one record in the table.

I have not tried any of this personally, but it seems it would work.

You could even add one more field... LetterName and allow them to maintain
multiple letters. When you run the 'report' they could pick with letter
text they want to use.
 
What I have is an Employer table. What would be the best way to set
the relationship between the form table and the Employer table?
 
Not sure what you are asking.

There would be no relationship between the table I mentioned earlier and any
other table. In your 'report' or 'letter' you'd simply pull data from the
table I mentioned and use it in your letter.

Obviously you could pull OTHER information from your table so that the
recipient's name and address would appaer on the letter.

In short, just make sure the query (upon which your report is built)
includes all the tables you need to construct the letter.
 
I have created a form letter using a report. It works fine if I set
everything up in the design view no problem. What I want to do is to
set it up so the body of the form letter can be changed without going
into design view by staff so they can change the letter.

I created an unbound form and put a unbound text field in the unbound
form and was hoping that I could use this by putting an unbound text
field in the Form Letter and having its properties associated with the
unbound text field in the unbound form. But what happens is I get a
?Name error.

Can I set up my changable form letter like this or do I need to do it
another way? Or what do I need to do to fix this?
Click to expand...

I'll agree with Rick and Duane (well, I usually do of course :-{)...)

I'm working on an app right now that has eleven form letters for
eleven cities, with anywhere from slight to major differences. I've
just got a table with the city's name and address, and Memo fields
Paragraph1, Paragraph2 and Paragraph3 (yes, everyone, take note - the
Normalization Cop has denormalized, but the letters have a common
format with varying content, and in this case it was reasonable).


John W. Vinson[MVP]
 
Back
Top