Create Letters in Access

B

Becky

We are in the process of converting from Lotus Approach to MS Access.
In Approach we could create letters that would add the fields we told it to.
We do not want to have to use the mail merge to Word. Can letters be
created in Access?
 
J

John Vinson

We are in the process of converting from Lotus Approach to MS Access.
In Approach we could create letters that would add the fields we told it to.
We do not want to have to use the mail merge to Word. Can letters be
created in Access?

Yes, though it's not ideal for the purpose, and probably more
difficult than Approach. You would create a Report with textboxes for
the various contents of the letter; you'll probably need to manually
adjust and lay out the textboxes so that it prints a nice-looking
letter.

John W. Vinson[MVP]
 
D

David Lloyd

Becky:

One option is to create a report as a letter. Each report has a record
source where you specify the data (table or query) that you want to use in
the report (letter). After defining a record source for the report
(letter), you can then add fields to the report (letter).

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


We are in the process of converting from Lotus Approach to MS Access.
In Approach we could create letters that would add the fields we told it to.
We do not want to have to use the mail merge to Word. Can letters be
created in Access?
 
B

Brucels

Having tried the same thing (well, actually, a membership dues statement in
letter format) in both Access and Word, I highly encourage you to use Word
mail merge; it's a lot easier to achieve the page formatting you desire.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top