How to document dates that the mailmerged letter is created

[huongdl1987]

Hi,



I want to generate a thank you letter using some informations from my ACCESS database. The problem is, we have 1400 participants in our studies and we only want to generate letters for about 100 people at a time. I have 2 questions:
1. I want ACCESS to automatically record the dates that the letter was printed. How do I do that?
2. I only use the mail merged and they generate letters to all participants. How do I create letters to only some, i.e. participants #200-359?

Thank you,
Meo

[JeroenMioch]

My knowledge about mail merging is limited but your first question should be simple. Just put code behind the button your generating the mail with and make an SQL statement where you put the print date in some field of your database.
If you need help on such a statement, let me know.

[huongdl1987]

I do need help on this statement! I'm using a table so I'm not sure where to put the buttons. Here is what I've in mind:

1. I want to select a group of participants that leave close together, i.e. Salt Lake City, Utah.
2. I want to send a thank you letter to this group.
3. Once the thank you letter was printed, access automatically documented the date that the letter was printed.

Thank you,
Meo

[JeroenMioch]

You dont have a form on wich your records are shown ?
If you just have the table and nothing more then coding such a thing is near impossible.

If what i mention above is correct i suggest you start by using the MS-access form wizard, and make a form based upon your table. Once you have done that we can filter the participants you want. e.g. : filter them by city or state so you have the group of participants you desire in your recordset.

Once you have this group, you can do the sending out of mails and together with that action print and dating the printout.