to print mail merge from excel

[ckishoreddys]

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

 

[Cindy M.]

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

Hmmm. Which version(s) of Word are you targeting with this? If Word
2002/2003 I have to ask why anyone would want to re-invent the wheel. The
"Recipients" dialog box allows the user to select exactly the records to
be merged from a list.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail