Writing Form Letter based on Access info

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

I need to write a form letter that can be changed based
on the various addresses and names in my database. Is
there any easy way to do this? I am having problems
getting a form to set up nicely.


Thanks

SS
 
You might want to consider using a MS Word mail merge, with your Access
database as its DataSource.

HTH
- Turtle
 
Using word & mailmerge is the BEST solution....

BUT

Create a report in your database that is a letter. In the header, add
appropriate fields for the addressees. I would base the report on a query
which parses the base data table.

You could create this query to be a query by form, then open the report from
the form.

With the appropriate use of pagebreaks in the form, you could insure that
the report prints out appropriately with contiguous letters.

Just a thought.
 
SS said:
I need to write a form letter that can be changed based
on the various addresses and names in my database. Is
there any easy way to do this? I am having problems
getting a form to set up nicely.
Click to expand...

There are 2 methods, depending upon what you need to do. If you need to send
numerous letters at once, build an Access query with the appropriate data
and run the mail merge wizard from Word. If you'd like to send one letter at
a time (i.e. a letter to the current record on a form) use automation with
Word bookmarks. An example of the latter methods is at:

http://www.datastrat.com/Code/WordMerge.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
There are 2 methods, depending upon what you need to do. If you need to send
numerous letters at once, build an Access query with the appropriate data
and run the mail merge wizard from Word. If you'd like to send one letter at
a time (i.e. a letter to the current record on a form) use automation with
Word bookmarks. An example of the latter methods is at:

http://www.datastrat.com/Code/WordMerge.txt
Click to expand...


That is absolutely brilliant, Arvin!

Thanks so much. You have saved me hours!
 
Back
Top