Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
to print mail merge from excel
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
to print mail merge from excel
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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format Fractions in Mail Merge. | Mailmerge | |||
Numeric rounding problems in mail merge with excel data source. | Mailmerge | |||
Mail Merge does not accept formatted cell of Excel | Mailmerge | |||
2003 Small Business - Mail Merge from Excel Sheet Duplication Oddi | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge |