emails - mail merge : group data

[neveu]

hello forum,

i would need your help for the following chalenge:

i have a database with 13 columns that has on column A the vendor number adn on column K the invoice amnt, on column L i have the email adress;
on column M i have a drop drown list (yes / no) . this enable the email to be sent to that specific adress.

what i would like to do is to send an email to each of the unique vendor number [it might be that a vendor number has several lines in the database] that would contain all the information from columns A to K for that specific vendor line.

the column O enables if that specific line should be included in the email or not.

[URL=http://imageshack.us/photo/my-images/546/mailmerge1.jpg/][IMG]http://img546.imageshack.us/img546/9964/mailmerge1.jpg[/IMG][/URL]
Uploaded with [URL=http://imageshack.us]ImageShack.us[/URL]

also i would need to include in the body of the message the total amnt of the invoice from that spefici vendor ; that would be the sum of the amnts in column K .

here is a print screen on how my database would look and a print screen on how my mails should look.

[URL=http://imageshack.us/photo/my-images/3/mailmerge2.jpg/][IMG]http://img3.imageshack.us/img3/1300/mailmerge2.jpg[/IMG][/URL]
Uploaded with [URL=http://imageshack.us]ImageShack.us[/URL]

thank you in advance.