hi all,
        im new to vba.n i have searching for the code for a specific
requirement in which i need to print mail merge document for each row
of an excel .

     my excel format is as follows and a mail merge document is also
created for the sake of formatted printout

   name          date      amount
   kate           12-2-05     5000/-
   james         1-1-06      6000/-

and a print button beside this data..if i click on print button,it has
to show dialog box with yes or cancel options for each row in
excel..and if yes button is clicked, it has to print the mail merged
document for that specific row..im not sure how to handle this as im a
beginer

can anyone please help me out