Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-13-2019, 05:23 PM
mdlewis mdlewis is offline VBA Split of Mail Merge Doc randomly hangs Windows 7 64bit VBA Split of Mail Merge Doc randomly hangs Office 2010
Novice
VBA Split of Mail Merge Doc randomly hangs
 
Join Date: Jan 2019
Posts: 11
mdlewis is on a distinguished road
Default VBA Split of Mail Merge Doc randomly hangs

I have macro code which splits a merge doc for each record and once split, loads tables from Excel and images from a folder. It works. On my single user machine it splits the docs and fills the tables etc. On a user's via Citrix on a network, it may work totally, or hang randomly after the 1st record's doc is created. I suspect insufficient memory or available virtual disc as the typical user may have many other applications open.

Is there a statement I can include in the code to release memory after each iteration of the splitting loop?



Have other users experienced this problem?
Reply With Quote
 

Tags
word;maiimerge;vba



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 02:27 PM.


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