Form Letters & Merge

  • Thread starter Thread starter 101ONT LTD
  • Start date Start date
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.
 
If you are just producing form letters, you are likely to be _much_
better off using Word's mailmerge facilities with your Access query as
a data source. Word handles this sort of formatting issue much better
and more conveniently than Access.

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.
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
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
 
The textbook way of doing what you are trying to do (Field included in
text paragraph) goes something like this:

Include a Control for the County name from the Query in the
appropriate section of the Report (call it fldCounty), but make it
inVisible.

Where you actually want the text to appear, add an unbound TextBox
(call it txtCounty), whose data source is
="The source in " & fldCounty & " is not found"

txtCounty should be long enough to contain the fixed text plus the
longest possible County name - the whole sentence will appear left
justified (by default) in the box, without unwanted spaces.

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

-----Original Message-----
If you are just producing form letters, you are likely to be _much_
better off using Word's mailmerge facilities with your Access query as
a data source. Word handles this sort of formatting issue much better
and more conveniently than Access.




Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
.
Click to expand...
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top