Creating a customized letter

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I am trying to create an appointment reminder letter to
send to customers. I would like to use MS Access Reports
rather than mail merging with Word since this is part of
a push button forms application. The text of the
document basically says:

Dear Chuck,

This is a reminder that it has been 30 days since your
last visit with Dr. Jones. If you would like to schedule
another appointment for a Chiropractic Adjustment, call
us at (444) 333-2222.

ABC Clininc

There are certain fields in my query which correspond to
the letter. They include the number of days (30 days for
this example), the doctors name (Dr. Jones), and the type
of treatment (Chiropractic Adjustment). There are four
pracititioners who each perform a couple of treatments
each with different reminder times (i.e. 30 days).

Is there a way to create a report which pulls data from a
query and places it in a report that can then be printed
and mailed to our customers?

Thanks,

Chuck
 
You could add text boxes to the detail section of the
report and use concatenation. Here's an example: (The
items in brackets would be pulled from the queries.)

NOTE: Please note that I did this on the fly and I may
not have accounted for the proper spacing. But if you try
this you'll get the point and you can adjust where
necessary.

Text Box 1:
="Dear "&[Name]&":"

Text Box 2:
="This is a reminder that it has been"&[DaysSinceLastVisit]
&" days since your last visit with "&[Doctor'sName]&" .
If you would like to schedule another appointment for a
Chiropractic Adjustment, call
us at (444) 333-2222."

TextBox 3:
="ABC Clininc"

Hope this helps,
Loretta
 
I do this all the time. I use it for Non-Profit Event Thank You letters.

I have a table with the necessary data
then create a query based on table (so i can set my date range ( i use by
year)
then use report wizard and base it on query.
Then i just put the fields where I want, and for custom text like "thank you
*** for your donation I use labels (to allow me to add my thank you letter
text.

It is pretty simple and ends up looking nice.
then when you open the report, it prompts you for your predesignated "query
parameter" and bingo/bango, generates the appropriate thank you letters.
I'm sure you could do the same for your purpose.

Let me know,
_Bigred
 
Back
Top