[jojopangit]

sir,i want to send a mail merge of outstandings of various bills to a list of customer. One customer may have more than one bill. I do not want to send many mails to the same customer. each mail merged page should countain the complete list of the bills and the total outstanding amount of each customer.

how do i do that using visual basic 6 and sql server 2000 as my database.

sample data :

tblproduction
assured inv no. amount
jude ulanday 001 1500
jude ulanday 002 500
judy ann santos 003 3000

target output :
__________________________________________________ _____________
page 1

dear mr. jude ulanday
you have outstanding balance amounting to 2,000.00, details as follows :
001 1500.00
002 500.00


__________________________________________________ ______________
page 2

dear ms. judy ann santos,
you have outstanding balance amounting to 3,000.00, details as follows :
003 3000.00
__________________________________________________ _____________
i hope i explain myself clearly.

thanks in advance for your help.