| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge question
I have an excel spreadsheet with 2 columns. One has a Name...the other a Number: John Doe 2 Jane Doe 4 etc. The number represents the number of times the name needs to be printed...for example....I need two sheets of paper with JOHN DOE printed on it and four sheets of paper with JANE DOE printed on it. Is there a way to do this with mail merge or any other method? Thanks! -- rfikes ------------------------------------------------------------------------ rfikes's Profile: http://www.officehelp.in/member.php?userid=4934 View this thread: http://www.officehelp.in/showthread.php?t=1250030 Posted from - http://www.officehelp.in |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail merge question
I wouldn't do it with mailmerge. It could however be done with some vba
code. I would use a DocVariable field in the document and interate through the data source setting the value of the variable to the data in the first column and printing as many copies required by the number in the second column before moving on to the next record in the data source. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "rfikes" wrote in message ... I have an excel spreadsheet with 2 columns. One has a Name...the other a Number: John Doe 2 Jane Doe 4 etc. The number represents the number of times the name needs to be printed...for example....I need two sheets of paper with JOHN DOE printed on it and four sheets of paper with JANE DOE printed on it. Is there a way to do this with mail merge or any other method? Thanks! -- rfikes ------------------------------------------------------------------------ rfikes's Profile: http://www.officehelp.in/member.php?userid=4934 View this thread: http://www.officehelp.in/showthread.php?t=1250030 Posted from - http://www.officehelp.in |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail merge question
Thank you. I suspected I would have to go to either VBA or Access for this.
I have a couple of "Learn *** in 21 days" at home. I'll dig them out and begin the learning. Thanks, again! -- dab4211 "Doug Robbins - Word MVP" wrote: I wouldn't do it with mailmerge. It could however be done with some vba code. I would use a DocVariable field in the document and interate through the data source setting the value of the variable to the data in the first column and printing as many copies required by the number in the second column before moving on to the next record in the data source. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "rfikes" wrote in message ... I have an excel spreadsheet with 2 columns. One has a Name...the other a Number: John Doe 2 Jane Doe 4 etc. The number represents the number of times the name needs to be printed...for example....I need two sheets of paper with JOHN DOE printed on it and four sheets of paper with JANE DOE printed on it. Is there a way to do this with mail merge or any other method? Thanks! -- rfikes ------------------------------------------------------------------------ rfikes's Profile: http://www.officehelp.in/member.php?userid=4934 View this thread: http://www.officehelp.in/showthread.php?t=1250030 Posted from - http://www.officehelp.in |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NO CODE - mail merge to Outlook with attachment with CC | Mailmerge | |||
| Heavy Mail Merge Application | Mailmerge | |||
| Mail Merge Losing Data | Mailmerge | |||
| Mail Merge - Parameter prompts twice... | Mailmerge | |||
| Word 2003 and Access 2003 Mail Merge question | Microsoft Word Help | |||
Linear Mode
