[AccessD] Mail Merge form letters

For examples see this site

http://www.helenfeddema.com/access.htm
Merging to Word from Linked Access Tables accarch44.zip
92. Mail Merge Mysteries accarch92.zip

http://www.helenfeddema.com/CodeSamples.htm
There are half a dozen samples here
Merging to Word Four Ways
6/9/2002
Demonstrates four ways to merge Access data to Word documents – Word 
document properties, bookmarks, the TypeText method and DDE mail merge. 
Both Access 97 and Access 2000 databases are provided; the Access 2000 
database also works in Access 2002. code24.zip
----------------
Also note if using Word 2002

in Access 2002 that VBA Mail Merges using OpenDataSource and Connection 
(Name: Query...) which uses
the old DDE technology, is broken. It was used in all previous versions 
of Access. Also, any DDE queries using the Connection method with (Name:
Query...) also If any query parameters are required, or any calculations 
done, or anything special, done to the standard select query,
Within WORD 2002, you CANNOT merge with a QUERY, unless you EXPORT the 
file from within Access and first, save the file as ‘Microsoft Word 
Merge’ file type
For info if you use these methods with Word 2002, this may have been 
fixed with an SP I am not sure.
http://www.engr.psu.edu/www/trg/isis/docs/Access2002-Merge-Datawarehouse-Notes-New.htm

connie.kamrowski at agric.nsw.gov.au wrote:

>Hi,
>
>I have just tried searching the archive for info and have some but could
>use a few hints.
>
>I have just written a DB which keeps track of Exhibited animals in our
>state. The client needs tio be able to send licences to exhibit to each of
>his customers as they apply and are accepted or rejected. I have set up a
>mail merge template in word which gets data from the relevant query. Each
>copy of the document will be of varying content based on wether conditions
>are imposed or not.
>
>I have never done this before and so need some advise from those who have.
>
>How do I set this up to print a copy of the letter for every record in a
>range of records? if they have 200 new approvals I need to generate a
>letter for each of the approvals in a range entered. What is the best way
>to put this into the database and allow a user entered parameter for the
>range?
>
>All help appreciated
>
>Connie Kamrowski
>
>Analyst/Programmer
>Information Technology
>NSW Agriculture
>Orange
>
>
>
>This message is intended for the addressee named and may contain
>confidential information. If you are not the intended recipient or received
>it in error, please delete the message and notify sender. Views expressed
>are those of the individual sender and are not necessarily the views of
>their organisation.
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada