Form Letters & Merge

1

101ONT LTD

I've designed a form letter as an Access report. Is there
a formatting property like in Word to format my letters
when I print them (printing is done by clicking on a
command button on my Access form). The right margin is
o.k. but don't know how to adjust the left one so that all
lines are of the same lengths without having to continue a
word on 2 lines. Is ther something in 'properties' for
this?

I insert names in the body of my form letter. How do I
get the space between inserted fields and the text that
follows to be automatically adjusted. The inserted fields
are of varying lengths.

Any other suggestions would be much appreciated.
Thank you.
 
G

GenE Shockley

I have a similar problem.

I currently use WORD templates to produce about 16
different form documents. Each document has about 10
main fields that are all the same (i.e. name, number,
years, etc.) but each document has several fields unique
to that document. Additionally, I may need to produce
more than 1 document for the same "name".

If I set up a database that had all the recurring data +
the unique fields, then I could copy the additional
records by ctrl " and only need to update the unique
data. This would save a lot of key-strokes.

While I realize that I could use a mail merge system, I
find that on our office network, there is a delay in
transfering the information from Access to the Word
document, and also, this process would group print the
documents by type rather than by individual.

Additionally, at the current time our office tracks
completed work by a manual "tick" system, but I would
prefer the database also be used to track the statistics
of documents completed.

I usually have no problem building databases/reports,
however one document contains a paragraph that includes a
county name in the middle of the sentence/paragraph. (See
Below).

The source in [Bee ] County is not found.
The source in [San Augustine] County is not found.

As you can see, building the report with the county field
to hold the longer county name, will result in a lot of
trailing spaces after the shorter county name. I have
tried to research and experiment with trailing spaces,
and also grow and shrink with no sucess. I have no
experience using visual basic.

Any help at all would be very much appreciated. We are
using Access 2000.

Thanks, GenE Shockley
 
Top