#1
|
|||
|
|||
using mailmerge to include a grouped information in a letter
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. |
#2
|
||||
|
||||
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
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.
|
#4
|
||||
|
||||
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] |
#5
|
|||
|
|||
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. |
#6
|
||||
|
||||
See revised attachment in post 2.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
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. |
#8
|
||||
|
||||
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] |
#9
|
|||
|
|||
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. |
#10
|
||||
|
||||
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] |
#11
|
|||
|
|||
view: is screenshot
code from tuto: is the copied code test from tuto: is the output after testing the code on my blank page |
#12
|
||||
|
||||
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] |
#13
|
|||
|
|||
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.
|
#14
|
||||
|
||||
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] |
#15
|
|||
|
|||
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.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to insert an image to a word mailmerge document based on the value of a mailmerge field? | Jake93 | Mail Merge | 3 | 07-02-2019 05:38 PM |
Use L and R arrow to move cursor letter to letter, not top of the line | mellowkitten | Word | 2 | 05-12-2016 07:23 PM |
How to replace a letter to random letter with different color? | cikanoz87 | Word | 7 | 06-18-2015 09:43 PM |
Mailmerge with grouped data | Keith Henderson | Mail Merge | 14 | 02-04-2015 01:45 PM |
Directory MailMerge with Category Grouped Lists on Labels | screech | Mail Merge | 3 | 06-18-2014 11:41 PM |