Access (Mail Merge)???

[Jenny]

Hi,
On an Access report, I have a list of members who had
different medical tests on a report, but some members
just missed one of the different medical tests, now I
want to reminder those members with the missing test
information in a letter format.
Is there any way in Access xp to do this? Any suggestions
or examples will be greatly appreciated.

Thanks in advance!!!
Jenny

 

[Albert D. Kallal]

Can you build a query that shows those members?

In other words, the "trick" here is not to use your report, but can you
somehow build a query that returns only those with the missing test?

Once you got the query, then the rest is easy.

So, you can'y really drive this word merge from the report, but if you can
make a query then you are home free.

Once you got the query, then even my sample word merge code will work.


I have a nice sample word template merge from ms-access
that you can try out.

Check out:

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