Hello,

I'm looking for a solution to mail merge (type=directory) with a variable lengt table, without the use of macro's. This seems to work with copying the same merge fields on each line. However, because the datafile can contain 1, 100 or 10.000 records this is kind of shit because I have to add, by example, 10.000 empty lines. This can result in 1 file with a lot of pages while there is only data on the first page. I'm looking for a solution for this problem. Unfortunately the rule "next record" doesn't insert a new line in the table with the next record.

I added an example in this post.



I tried different options and searched a lot on google but I can't find a solution. Most posts on this forum are going above of my head and are solutions for more complex merge problems. Hope you guys can give me an easy solution based on the attached example.

Regards,
Ruud

Attached Files

	test.docx (12.7 KB, 16 views)
	test.txt (182 Bytes, 17 views)

Did you do a search? This issue has been discussed many times...
https://www.msofficeforums.com/mail-...ble-merge.html
https://www.msofficeforums.com/mail-...directory.html
https://www.msofficeforums.com/mail-...ail-merge.html
https://www.msofficeforums.com/mail-...ge-letter.html
https://www.msofficeforums.com/mail-...-supplier.html
https://www.msofficeforums.com/mail-...erge-send.html
etc., etc.

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

Hi,

I read the manual but it described a lot of situations which are more complex than the solution I was looking for. That's why I found it pretty hard to get the result I wanted and opened a thread.

However, I took some time to experimentalize and almost got the result I want. I managed to fill the table but I can't get it to work with a seperate header. Actually I just want to use a header in my table which doesn't repeat itself on each line. As well I'm looking to add text before or after the merge. By doing this the text keeps repeating itself for each line. Probably the same problem as with the header.

I tried to work with a continous section break but the merge ignores the sections. Any help with this would be much appreciated. I added the document again with the results so far. I used the same dataset as with the opening post.

Regards,
Ruud

Attached Files

Test.docx (14.1 KB, 16 views)

In the tutorial, the very first example, titled Merge Records By Category, provides the 'simple' solution. From there it builds ever more complex solutions, including solutions that address your need. All it takes is the time to read and apply. The hard work - the field coding - has all been done for you.

The DATABASE field examples that are linked to in those threads show yet another way of achieving the same end, as do the links to the 'Many to One' utilities.

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

Ok, I managed to get one step further.

Actually the tutorial on this website http://cornell.veplan.info/article.aspx?&a=3815 helped me to futher understand the coding from the mailmerge and how to edit it (ctrl+f9).

When trying to convert the output to a table MS Word automatically inserts a paragraph break which I can't delete in my mailmerge document. Is this even possible?

I tried to work with the macro from the manual, but this only delete's the paragraph break between the header and the first line. Am I doing something wrong?

Attached Files

Example.docx (15.3 KB, 18 views)

My tutorial provides everything you need for this, without requiring you to learn the intricacies of field coding. It even includes a macro for handling the splits that occur when working with tables. Did you even read the 'Merging to Tables' topic in the tutorial?

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

Hi There,

Yes I did read the manual. However, I executed the macro tablejoiner, and also tried the macro tablesummarize but it only merges my header line with the first tablerow...

I also tried it with the examples from the manual and it works fine there. Still don't understand why it doesn't work with my the doc which I attached in the previous post.

Started to edit my mailmerge document again by using 1 key and work with <>0 in stead of comparing 2 keys and then tried the tablejoiner macro and it works fine now.
Added the macro in the normal.dot.

Attached Files

Example_final.docx (15.5 KB, 20 views)