Hi,


I tried to use the {MERGESEQ} with {SET KEY=""} but did not succeed.


Would be very thankful if resolved.


Ali Mubarak

Attached Files

	Combinefile.xlsx (9.4 KB, 12 views)
	Due Within 1 Month.docx (12.6 KB, 11 views)

Since you haven't told us what you're trying to do and there's no field coding of any kind in your document - not even a single mergefield - we'd only be guessing what you're trying to achieve.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi,

YOU are right there is no code in the word document. I copied the code from mail merge forum to print a bill for each customer in the attached format of word document. BUT culd not understand the loop and filter.

Greatful if you may help to create the macro for.



AlI Munarak.

From what I can deduce from your workbook and document, 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 in the 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...-tutorial.html
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.

Depending on what you're trying to achieve, the field coding for this can be complex. However, since the tutorial document includes working field codes for all of its examples, most of the hard work has already been done for you - you should be able to do little more than copy/paste the relevant field codes into your own mailmerge main document, substitute/insert your own field names and adjust the formatting to get the results you desire. For some worked examples, see the attachments to the posts at:
https://www.msofficeforums.com/mail-...html#post23345
https://www.msofficeforums.com/mail-...html#post30327

Another option would be to use a DATABASE field in a normal ‘letter’ mailmerge main document and a macro to drive the process. An outline of this approach can be found at: http://answers.microsoft.com/en-us/o...1-1996c14dca5d
Conversely, if you restructure your workbook so you can use it like a relational database (i.e. with a separate sheet with just a single instance of each of the grouping criteria, a DATABASE field in a normal ‘letter’ mailmerge main document could be used without the need for a macro. An outline of this approach can be found at:
https://answers.microsoft.com/en-us/...f-8642e46fa103
For a working example, see:
https://www.msofficeforums.com/mail-...-multiple.html

As you can see from the above, it's quite possible to do what you appear to want to do without a macro.

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://onedrive.live.com/?cid=5AEDC...43615E886B!566

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I am greatful to you for such nice guid lines. I would go through the tutorial first and the said tool for writing the macro.

THANKS۔

AlI Mubarak

Hi,


First of all Thanks for guidance,


I read the Tutorial, and utilize the macro which is in attached file, but output is splitted/appears in multiple pages instead on one page for one customer.


Please guide me for the correction in macro.


Code file, Data file and Output File are attached.




Ali Mubarak

Attached Files

	Output.docx (15.9 KB, 10 views)
	Mailmerge Main Document.doc (40.0 KB, 11 views)
	Combinefile.xlsx (9.5 KB, 10 views)

You haven't followed all of the instructions - your mailmerge main document is configured for a Letter merge but the tutorial says you must use a Catalog or Directory merge.

You also seem to have only copied & pasted the field coding from the tutorial into your own document without modifying anything to suit your actual mailmerge data. Simply pasting your mergefields onto the output displayed by the tutorial is not what the tutorial says you need to do.

And, as I have said before, none of this has anything to do with a macro!

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi,


Yes, after Selecting the type as "Directory" the output of the bill starts consolidating on one page. I read the VB Scrip, it is good need little effort to incorpoare the scrip in the file.


Any ways Thank you for your generosity and guidance.


Regards,


Ali Mubarak

There is no 'VB Scrip' in your attachment. Neither does your attachment have the required changes to the field coding. Clearly you haven't paid attention to what the tutorial says or to the demonstration links I supplied.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi,


I attached the output of the macro,



I assumed as the following is the VB script to merge the "Tables".


Merging to Tables

Any of the previous examples can produce their output in a table format. All you need to do is to replace the heading & data lines in the field code with an equivalent table. When you do so, however, each record becomes a one-row table, as per the ‘Calculating Group and Sub-Group Totals’ example (page 14). To turn that output into one table per group you can run the following ‘TableJoiner’ macro after completing the merge.
Sub TableJoiner()
Application.ScreenUpdating = False
Dim oPara As Paragraph
For Each oPara In ActiveDocument.Paragraphs
With oPara.Range
If .Information(wdWithInTable) = True Then
With .Next
If .Information(wdWithInTable) = False Then
If .Text = vbCr Then .Delete
End If
End With
End If
End With
Next
Application.ScreenUpdating = True
End Sub




Regards,


Ali Mubarak

Attached Files

	Mailmerge Main Document.doc (39.5 KB, 10 views)
	Directory1.docx (17.2 KB, 10 views)

You still have not made the required changes to the field coding. Until you do that you are just wasting time - yours and mine. Read the tutorial!

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]