Writing Form Letter based on Access info

[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

 

[MacDermott]

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

HTH
- Turtle

 

[Grumpy Aero Guy]

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.

 

[Arvin Meyer]

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.

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

 

[Albert D. Kallal]

Download my working sample. It shows how to send one letter from the
current screen.

In addition, my code is setup to work with YOUR forms. The whole process of
creating, and making the template is handled by my software.

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

 

[Kelvin Wilson]

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

That is absolutely brilliant, Arvin!

Thanks so much. You have saved me hours!

 

[jilali affaoui srayoi]

That is absolutely brilliant, Arvin!

Thanks so much. You have saved me hours!