Share via

Repeating row equired in mail merge page

Anonymous
2014-04-02T12:01:39+00:00

Dear ms office Team,

how to create invoice in mail merge in word repeating rows,

like pls see the the below grid, 

INVOICE NO INVOICE DATE ITEM DESCRIPTION QTY RATE VALUE
1 01/04/14 BLUE PEN 10 3.5 35
1 01/04/14 RED PEN 10 4.5 45
1 01/04/14 BLACK PEN 10 4 40
2 01/04/14 BLUE PEN 100 3.5 350
2 01/04/14 RED PEN 10 4.5 45
3 02/04/14 BLUE PEN 50 3.5 175
3 02/04/14 RED PEN 10 4.5 45
3 02/04/14 BLACK PEN 10 4 40
3 02/04/14 GREEN PEN 100 4.5 450
4 02/04/14 BLACK PEN 50 4 200
4 02/04/14 GREEN PEN 60 4.5 270

but i am traying in mail marge in that singale row only comming we reqd mail merge invoice no wise reqd one sheet one invoice no,

can u pls hlep out this problem,

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Doug Robbins - MVP - Office Apps and Services 323K Reputation points MVP Volunteer Moderator
2014-04-03T11:08:55+00:00

The Many to One facility on my MergeTools - 20140218.dotm Add-in can create the sort of documents that you require.

You can download it from the following page of my One Drive:

http://bit.ly/1hduSCB

The file needs to be saved in the Word Startup folder.  In Windows XP the default location for that folder is

C:\Documents and Settings[User Name]\Application Data\Microsoft\Word\STARTUP

In Windows Vista and Windows 7, 8 or 8.1 it is

C:\Users[User Name]\AppData\Roaming\Microsoft\Word\STARTUP

When that has been done and Word is started\re-started, the tab shown below will be added to the Ribbon:

One thing to note is that the field names in the data source must contain only alphanumeric characters (No @,#,$,%,&,(,), etc) and the field names must not start with a numeric character (0-9).

Also download the Using the Many to One Facility document that describes how to use that facility.

Was this answer helpful?

0 comments

Answer accepted by question author

Paul Edstein 82,861 Reputation points Volunteer Moderator
2014-04-03T10:33:23+00:00

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:

http://windowssecrets.com/forums/showthread.php/154370-Microsoft-Word-Catalogue-Directory-Mailmerge-Tutorial

or:

http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip

The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.

For some worked examples, see the attachments to the posts at:

http://www.msofficeforums.com/mail-merge/9180-mail-merge-duplicate-names-but-different-dollar.html#post23345

http://www.msofficeforums.com/mail-merge/11436-access-word-creating-list-multiple-records.html#post30327

http://windowssecrets.com/forums/showthread.php/157725-Word-2010-Merge-from-excel-into-Table-Directory?p=928391&viewfull=1#post928391

Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from:

Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or

Doug Robbins at https://skydrive.live.com/?cid=5aedcb43615e886b#!/?cid=5AEDCB43615E886B!cid=5AEDCB43615E886B&id=5AEDCB43615E886B%21566

In addition to a 'Many to One' merge, the latter handles:

• Merge with Charts

• Duplex Merge

• Merge with FormFields

• Merge with Attachments

• Merge to Individual Documents

• Merge, Print and Staple

Was this answer helpful?

0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-04-03T10:22:24+00:00

    Hello,

    Are you using Excel file as the data source for the mail merge?

    If yes, then Word will perform mail merge corresponding to the number of records in Excel.

    You may go through the article given below which provides information on how to do ‘Mail Merge using an Excel spreadsheet’:

    http://office.microsoft.com/en-001/word-help/mail-merge-using-an-excel-spreadsheet-HA102809678.aspx

    For further queries, reply and we would be happy to assist.

    Thank you.

    Hi Nayana,

    but my problem got not solved,

    what I am expecting in mail merge see the below,

    for example one sheet one invoice details like below  

    INVOICE NO INVOICE DATE ITEM DESCRIPTION QTY RATE VALUE
    1 01/04/14 BLUE PEN 10 3.5 35
    1 01/04/14 RED PEN 10 4.5 45
    1 01/04/14 BLACK PEN 10 4 40

    sheet no # reqd invoice no#02 details

    INVOICE NO INVOICE DATE ITEM DESCRIPTION QTY RATE VALUE
    2 01/04/14 BLUE PEN 100 3.5 350
    2 01/04/14 RED PEN 10 4.5 45

    can u pls help this problem,

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-04-03T06:34:27+00:00

    Hi Nayana,

    but my problem got not solved,

    what I am expecting in mail merge see the below,

    for example one sheet one invoice details like below  

    INVOICE NO INVOICE DATE ITEM DESCRIPTION QTY RATE VALUE
    1 01/04/14 BLUE PEN 10 3.5 35
    1 01/04/14 RED PEN 10 4.5 45
    1 01/04/14 BLACK PEN 10 4 40

    sheet no # reqd invoice no#02 details

    INVOICE NO INVOICE DATE ITEM DESCRIPTION QTY RATE VALUE
    2 01/04/14 BLUE PEN 100 3.5 350
    2 01/04/14 RED PEN 10 4.5 45

    can u pls help this problem,

    Was this answer helpful?

    0 comments
  3. Anonymous
    2014-04-03T05:57:48+00:00

    Hello,

    Are you using Excel file as the data source for the mail merge?

    If yes, then Word will perform mail merge corresponding to the number of records in Excel.

    You may go through the article given below which provides information on how to do ‘Mail Merge using an Excel spreadsheet’:

    http://office.microsoft.com/en-001/word-help/mail-merge-using-an-excel-spreadsheet-HA102809678.aspx

    For further queries, reply and we would be happy to assist.

    Thank you.

    Was this answer helpful?

    0 comments