Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page VBA Split of Mail Merge Doc randomly hangs VBA Split of Mail Merge Doc randomly hangs
Register FAQ Mark Forums Read

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 11-16-2019, 03:07 AM
gmayor's Avatar
gmayor gmayor is offline VBA Split of Mail Merge Doc randomly hangs Windows 10 VBA Split of Mail Merge Doc randomly hangs Office 2016
Expert
  
Join Date: Aug 2014
Posts: 4,143
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
Quote:
Originally Posted by mdlewis View Post
Is there a statement I can include in the code to release memory after each iteration of the splitting loop?
Add the line
Code:
DoEvents
after each iteration.
You may find Merge and Split useful
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
 

Tags
word;maiimerge;vba

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Threaded Mode Threaded Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Split of Mail Merge Doc randomly hangs Mail Merge does not split tables if entry has a number in front B-Man Mail Merge 5 05-19-2019 07:25 AM
VBA Split of Mail Merge Doc randomly hangs Mail Merge - split merged documents and rename each split document based on text in header FuriousD Word VBA 1 05-12-2019 04:06 AM
Help Please: New VBA user trying to use a macro to split Mail Merge documents. Two Run-Time Error zipit189 Word VBA 7 03-18-2015 01:13 PM
VBA Split of Mail Merge Doc randomly hangs Split each page of mail merge into separate pdf Declan Mail Merge 1 05-28-2014 02:02 AM
VBA Split of Mail Merge Doc randomly hangs Automatically split Mail Merge based on number of pages SaneMan Mail Merge 1 12-03-2011 01:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:43 AM.

Contact Us - Privacy Statement - Top

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