#31
|
||||
|
||||
Either you're not using the attachment I provided or, by saving it in the docx format, you have deleted the macro. MS Word would have warned you about that.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#32
|
|||
|
|||
Quote:
It is possible that, wihout knowing, I deleted the macro when I was replacing the code you provided by the existing code of the main document. I remember on the menu I went to view-macro and replaced the code that existed there by the code you provided. I don’t know how to proceed. |
#33
|
||||
|
||||
Quote:
Try the attached.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#34
|
|||
|
|||
Thank you for your effort, unfortunately the print out is the same as the previous code (no monthly subtotals) and general total
|
#35
|
||||
|
||||
That simply is not possible unless you disabled (or failed to enable) the macro.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#36
|
|||
|
|||
I perfectly enabled macros as you can see on attached screenshot. The first screenshot is what I used to print the document
|
#37
|
||||
|
||||
Your 1st screenshot tells me nothing about whether macros have been enabled.
Your 2nd screenshot tells me Word is waiting for you to respond to the macro warning. Even if you enable macros, the included macro will only run if you actually complete the merge (i.e. via Finish & Merge>Edit Individual documents).
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#38
|
|||
|
|||
To complete the merge is what I did incorrectly. I did Finish & Merge> Print documents instead of Finish & Merge> Edit Individual documents. Thank you for all your guidance during these weeks long and perhaps tiresome demands from me. Now the code works perfectly, thank you abundantly. I also apologize for my English, it is not my first language.
|
#39
|
|||
|
|||
@MacroPod,
Thanks for the posting and that he task can be completed. However, using your example files and extending the data for a larger merge, I see that it is a slow process. Tested at 25 Clients and took several minutes. My target merge will have ~800 "clients" It appears that during the merge, the DATABASE field is reconnecting to the table to run the new query. I like the DATABASE field method, however, would you suggest a different methodology for larger merges? Best speed method? |
#40
|
||||
|
||||
That is an extraordinarily long time for just 25 clients - it should complete in a few seconds. And, even at 800 clients, I'd expect completion in well under 1 minute. I suspect your system/merge has other issues you haven't told us about.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
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 |