Printing Letter with printing base on Title in Grid

[Ali Mubarak]

Hi,




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


Would be very thankful if resolved.


Ali Mubarak

[macropod]

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.

[Ali Mubarak]

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.

[macropod]

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

[Ali Mubarak]

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

[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

[macropod]

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!

[Ali Mubarak]

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

[macropod]

Originally Posted by Ali Mubarak

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.

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.

[Ali Mubarak]

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

[macropod]

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!