Letters Generation Database

[Kaylen]

I am seeking direction on how to create a database of auto generation
letters. I would like to have information entered into a form and the data
entered in the form will be used to generate letters. I know how to create
forms and tables. I just don't know how to go about creating the letter
templates and how to transfering the data from a table into those letters
templates that would auto generate the letters. I would like the field to
grow and shrink according to the entered text size. For example:

"This letter is to inform _____that......"

I would like the "____" to grow and shrink relative to the size of the text
going to be entered so in the end, the letter will look professional, not a
big or tight gap between the words.
So do I enter the template text into the report design view? What if the
letter template is going to be 4-5 pages long? I think there is a limit to
the size of the design view, and that would be a problem for a letter that
might be 4-5 pages long. Any help is greatly appreciated.

 

[fredg]

I am seeking direction on how to create a database of auto generation
letters. I would like to have information entered into a form and the data
entered in the form will be used to generate letters. I know how to create
forms and tables. I just don't know how to go about creating the letter
templates and how to transfering the data from a table into those letters
templates that would auto generate the letters. I would like the field to
grow and shrink according to the entered text size. For example:

"This letter is to inform _____that......"

I would like the "____" to grow and shrink relative to the size of the text
going to be entered so in the end, the letter will look professional, not a
big or tight gap between the words.

Use an UNBOUND text control
="This letter is to inform " & [NameField] & " that the amount of " &
[BalanceDueField] & " is due on etc..... "

 

[Kaylen]

I'm sorry if I am slow, but I'm not familiar with UNBOUND text control. Can
you give me step by step instructions?

I am seeking direction on how to create a database of auto generation
letters. I would like to have information entered into a form and the data
entered in the form will be used to generate letters. I know how to create
forms and tables. I just don't know how to go about creating the letter
templates and how to transfering the data from a table into those letters
templates that would auto generate the letters. I would like the field to
grow and shrink according to the entered text size. For example:

"This letter is to inform _____that......"

I would like the "____" to grow and shrink relative to the size of the text
going to be entered so in the end, the letter will look professional, not a
big or tight gap between the words.

Use an UNBOUND text control
="This letter is to inform " & [NameField] & " that the amount of " &
[BalanceDueField] & " is due on etc..... "

So do I enter the template text into the report design view? What if the
letter template is going to be 4-5 pages long? I think there is a limit to
the size of the design view, and that would be a problem for a letter that
might be 4-5 pages long. Any help is greatly appreciated.

 

[fredg]

I'm sorry if I am slow, but I'm not familiar with UNBOUND text control. Can
you give me step by step instructions?

I am seeking direction on how to create a database of auto generation
letters. I would like to have information entered into a form and the data
entered in the form will be used to generate letters. I know how to create
forms and tables. I just don't know how to go about creating the letter
templates and how to transfering the data from a table into those letters
templates that would auto generate the letters. I would like the field to
grow and shrink according to the entered text size. For example:

"This letter is to inform _____that......"

I would like the "____" to grow and shrink relative to the size of the text
going to be entered so in the end, the letter will look professional, not a
big or tight gap between the words.

Use an UNBOUND text control
="This letter is to inform " & [NameField] & " that the amount of " &
[BalanceDueField] & " is due on etc..... "

So do I enter the template text into the report design view? What if the
letter template is going to be 4-5 pages long? I think there is a limit to
the size of the design view, and that would be a problem for a letter that
might be 4-5 pages long. Any help is greatly appreciated.

An unbound text control is ANY text control whose control source is
NOT BOUND to a field in a table or query. The usual method to add an
unbound text control to a form or report is to drag the text control
from the ToolBox tool button.
If you do so, and then look at the control's control source property
you will see that it is blank.

 

[Kaylen]

Thank you, I finally got it!
Now my problem is that I have many conditional pragapraghs. A letter is to
include a certain paragrpah if a conditon is met or not met. For example, if
a balance is
overdue more than 90 days, we need to include a collection paragraph, if not
then that paragragh will not be included. Tha is just an example of one, I
have multiple conditonal paragraphs within one single letter and there can be
20 versions of that same letter because of many possibile combination of
conditons. I want to have one template that allows the users to choose the
conditions and a
letter will be generated from those conditions. How would I go about
programing or creating a letter template that would allow this? Please help!!

I'm sorry if I am slow, but I'm not familiar with UNBOUND text control. Can
you give me step by step instructions?

On Tue, 18 Nov 2008 10:55:01 -0800, Kaylen wrote:

I am seeking direction on how to create a database of auto generation
letters. I would like to have information entered into a form and the data
entered in the form will be used to generate letters. I know how to create
forms and tables. I just don't know how to go about creating the letter
templates and how to transfering the data from a table into those letters
templates that would auto generate the letters. I would like the field to
grow and shrink according to the entered text size. For example:

"This letter is to inform _____that......"

I would like the "____" to grow and shrink relative to the size of the text
going to be entered so in the end, the letter will look professional, not a
big or tight gap between the words.

Use an UNBOUND text control
="This letter is to inform " & [NameField] & " that the amount of " &
[BalanceDueField] & " is due on etc..... "

So do I enter the template text into the report design view? What if the
letter template is going to be 4-5 pages long? I think there is a limit to
the size of the design view, and that would be a problem for a letter that
might be 4-5 pages long. Any help is greatly appreciated.

An unbound text control is ANY text control whose control source is
NOT BOUND to a field in a table or query. The usual method to add an
unbound text control to a form or report is to drag the text control
from the ToolBox tool button.
If you do so, and then look at the control's control source property
you will see that it is blank.