Mailing Selection

[giahan]

Hi all,

I have a table like this:

DocId Author Man1 Man2 Expire File

1 A1 M1A M2A 10/9/00 test1.txt
2 A1 M1A M2A 10/9/00 test2.txt

3 A2 M1B M2A 10/9/00 test3.txt
4 A2 M1B M2B 10/9/00 test4.txt

6 A3 M1C M2B 10/9/00 test5.txt
7 A3 M1C M2B 10/9/00 test6.txt

I have to send an email message to Author A1, A2, A3 (only 1 message to each) with the content like "your file has been expired. Please notify to your Man1, Man2"

Man1, Man2 (M1A, M1B, M1C, M2A, M2B, M2C) also received 1 (only one) email message with the content like "Files has been expired -- Please approve by clicking on this link

http://mycomp.com/approve.cfm

My question is how do I write cfm file(specifically, the conditions) so that it only sends one message to each author, Man1, Man2.

Any help will be appreciated.
Thanks


[sig]<p>GH<br>[/sig]