James SN

James SN

  • NA
  • 13
  • 0

Sending Email with list of data to each Recepient

Apr 7 2009 5:05 AM

Hi,
Let's say i've follow table,
tblData
UsrMail        | ItemCd    | EndDte
---------------------------------------
[email protected]  | 0023      | 4/13/2009
[email protected]  | 0021      | 4/11/2009
[email protected]  | 0029      | 4/17/2009
[email protected]  | 0114      | 4/16/2009
[email protected]  | 0189      | 4/12/2009
[email protected]  | 0099      | 4/16/2009
[email protected]  | 0067      | 4/18/2009
[email protected]  | 0077      | 4/11/2009
[email protected]  | 0027      | 4/14/2009
[email protected]  | 0649      | 4/13/2009

How my program will group Email content by UsrMail? So, my program can mail UsrMail with a list of data. My expected

result like

In [email protected] mailbox, it will get
ItemCd   | EndDte
---------------------
0023     | 4/13/2009
0067     | 4/18/2009

In [email protected] mailbox, it will get
ItemCd   | EndDte
---------------------
0021     | 4/11/2009
0114     | 4/16/2009
0099     | 4/16/2009
0077     | 4/11/2009

In [email protected] mailbox, it will get
ItemCd   | EndDte
---------------------
0029     | 4/17/2009
0189     | 4/12/2009
0027     | 4/14/2009
0649     | 4/13/2009

Really need techincal answer


Answers (2)