Hello,


I wish to prepare a letter to debtors of my company showing them invoices not yet paid so that they can pay. The letter should contain invoice number, invoice date and amount of that invoice. I have a long list of debtors to write to and I am wondering if mail merge could help me doing so. Each debtor has a long list of invoices which I want to group on one letter sent to that debtor (one letter can have more than one page).

I tried to use the technique of "Microsoft Word Catalogue/Directory Mailmerge Tutorial", but the code provided in the tutorial is not working because I am very beginner in this kind of mail merge, I don’t know how to do it. I copied the code contained in the tutorial but I failed to connect the code with the table containing the data of my debtors.

I attach my excel document containing data I want to insert into a letter. I also attach my letter but the code is not working. If you can provide me some help I would be thankful.

Attached Files

	list.xls (19.0 KB, 17 views)
	letter.docx (12.0 KB, 17 views)

You really don't appear to have invested any more effort in this than copying the field code from the mailmerge main document into your own document. You haven't even bothered to insert any of your own mergefields. As discussed under the topic Merging to Tables and demonstrated in Calculating Group and Sub-Group Totals in the tutorial, you need to incorporate your table header row and a data row into to field code.

See attached.

Attached Files

letter.docm (21.0 KB, 23 views)

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

Thank very much for your help. However, I am having a problem of showing the data in group form. Data is coming in single entry. Kindly find attached the the result I have.

Attached Files

letter-2.docx (17.2 KB, 19 views)

You need to at least read the tutorial, especially the topics Introduction and Set Up the Main Mailmerge Document.

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

Thank you, I followed all the steps from 1 to 8 of Set Up the Main Mailmerge Document. I may have made an error somewhere but I don't know where.
On my mail merge document directory submenu is active. Browser was done to identify my source data. But the result is not as intended, only one entry is being displayed per page.

See revised attachment in post 2.

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

Hello,
I used the document as you advised but at the time of Edit individual document, I received this message: "The macros in this project are disabled. Please refer to the online help or documentation for the host application to determine how to enable macros."
Thank you for your patience in helping me.

Go to File|Options|Trust Center>Trust Center Settings and choose the second item - 'Disable all macros with notification'. That will allow you to choose whether to enable macros in a document. The attachment to post 2 contains a macro that's needed to make the table generation seamless when you click on Finish & Merge>Edit Individual Documents.

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

Hello again,
I am using Microsoft word 2007 and file>option is not visible. I have word options and I cannot see Trust Center Settings. Kindly find my screen on attachment.

On the other hand, I tried the code contained in the tutorial Using Mailmerge To Create Category-Based Lists. I copied it and pasted it on a blank page of Microsoft word 2007. The code I used is the one contained under this heading: Using an Extra Field to Generate the Trailing Content Per Group (Using One Key). If the code had accepted to work, I could have replaced merge fields and put my own from my own data source. Unfortunately, the code did not provide same results as those contained in the tutorial. It is repeating all information below the list after putting the first list item and before putting a next, whereas in the tutorial, all list items are presented before putting concluding information.

I am really a beginner in this matter and I really need your help because I have to work with long list of debtors each one with a number of invoices.

Your help is highly welcome. Thank you for helping me.

Kindly update your profile to accurately reflect the OS & Office version you're using. There is also nothing attached to your post.

See: Expand your file-protection options via Microsoft Office 2007's Trust Center - CNET

Regardless, the mailmerge can be used without the macro embedded in the attachment, but then you'll need to use the TableJoiner macro in the tutorial - or join all the table rows manually.

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

view: is screenshot
code from tuto: is the copied code

test from tuto: is the output after testing the code on my blank page

Attached Files

	view.docx (203.9 KB, 12 views)
	code from tuto.docx (13.7 KB, 14 views)
	test from tuto.docx (13.8 KB, 9 views)

So click on 'Word Options'...

As for your other attachments, I have already supplied a document with fully-tested and working field coding in post #2.

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

Yes, the attachment in post no.2 is what I am using. And I did Trust Center but I receive the same message, see the screen shot on attachment.

Attached Files

trust center.docx (416.8 KB, 15 views)

Your second screenshot shows that Word has given you a macro security alert, next to which is an Options button. Click on that and enable macros.

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

Thank you macropod , the code works, but as a beginner I don't understand why concluding phrase is put before introductory phrase in the code. I will keep trying to make a desired content (putting totals) and font (Bold, Italics, font style). I will come back after some time to tell you that I have been able to produce desired letter. Thank you abundantly. God bless you.