Mailmerge from filtered records

[Malcolm H]

I have a database of names and addresses (Access 2003) and wish to be able
to mailmerge from a filtered selection of records.
If I perform a 'Filter by Form' to get the required list of addresses to be
merged, and then perform a mailmerge in Word 2003, it imports ALL the
records, not only the filtered ones as required.
Why is this? How can I merge only the required selection of records?

 

[Brendan Reynolds \(MVP\)]

Filter by Form determines only what records are displayed in that form. It
does not change in any way what records are available to an external
application, or even to another form or report within the Access
application.

If you want to control the filtering from within Access, you could automate
Word or simply export the result of a query to a Word document and have Word
use that document as the source for the mail merge. Otherwise, you can do
the filtering from within Word itself - the mail merge feature in Word has
its own filtering options.

 

[Albert D. Kallal]

You can give my word merge example a try. It should work for filtered
records.

Check out:

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