Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #31  
Old 06-09-2020, 01:01 AM
macropod's Avatar
macropod macropod is offline using mailmerge to include a grouped information in a letter Windows 7 64bit using mailmerge to include a grouped information in a letter Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,434
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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
[MS MVP - Word]
Reply With Quote
  #32  
Old 06-09-2020, 05:53 AM
Tesla Tesla is offline using mailmerge to include a grouped information in a letter Windows 7 32bit using mailmerge to include a grouped information in a letter Office 2007
Advanced Beginner
using mailmerge to include a grouped information in a letter
 
Join Date: Sep 2018
Posts: 44
Tesla is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.


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.
Reply With Quote
  #33  
Old 06-09-2020, 02:59 PM
macropod's Avatar
macropod macropod is offline using mailmerge to include a grouped information in a letter Windows 7 64bit using mailmerge to include a grouped information in a letter Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,434
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Quote:
Originally Posted by Tesla View Post
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.
Unlikely, as an empty code module would still be there.

Try the attached.
Attached Files
File Type: doc Mailmerge Letter.doc (53.0 KB, 1 views)
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #34  
Old 06-10-2020, 02:07 AM
Tesla Tesla is offline using mailmerge to include a grouped information in a letter Windows 7 32bit using mailmerge to include a grouped information in a letter Office 2007
Advanced Beginner
using mailmerge to include a grouped information in a letter
 
Join Date: Sep 2018
Posts: 44
Tesla is on a distinguished road
Default

Thank you for your effort, unfortunately the print out is the same as the previous code (no monthly subtotals) and general total
Reply With Quote
  #35  
Old 06-10-2020, 02:10 AM
macropod's Avatar
macropod macropod is offline using mailmerge to include a grouped information in a letter Windows 7 64bit using mailmerge to include a grouped information in a letter Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,434
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Quote:
Originally Posted by Tesla View Post
Thank you for your effort, unfortunately the print out is the same as the previous code (no monthly subtotals) and general total
That simply is not possible unless you disabled (or failed to enable) the macro.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #36  
Old 06-10-2020, 05:48 AM
Tesla Tesla is offline using mailmerge to include a grouped information in a letter Windows 7 32bit using mailmerge to include a grouped information in a letter Office 2007
Advanced Beginner
using mailmerge to include a grouped information in a letter
 
Join Date: Sep 2018
Posts: 44
Tesla is on a distinguished road
Default

I perfectly enabled macros as you can see on attached screenshot. The first screenshot is what I used to print the document
Attached Files
File Type: docx screenshot.docx (398.2 KB, 3 views)
Reply With Quote
  #37  
Old 06-10-2020, 03:30 PM
macropod's Avatar
macropod macropod is offline using mailmerge to include a grouped information in a letter Windows 7 64bit using mailmerge to include a grouped information in a letter Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,434
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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
[MS MVP - Word]
Reply With Quote
  #38  
Old 06-10-2020, 11:04 PM
Tesla Tesla is offline using mailmerge to include a grouped information in a letter Windows 7 32bit using mailmerge to include a grouped information in a letter Office 2007
Advanced Beginner
using mailmerge to include a grouped information in a letter
 
Join Date: Sep 2018
Posts: 44
Tesla is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
using mailmerge to include a grouped information in a letter Macro to insert an image to a word mailmerge document based on the value of a mailmerge field? Jake93 Word VBA 3 07-02-2019 05:38 PM
using mailmerge to include a grouped information in a letter 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
using mailmerge to include a grouped information in a letter 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:24 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft