View Single Post
 
Old 11-13-2019, 05:23 PM
mdlewis mdlewis is offline Windows 7 64bit Office 2010
Novice
 
Join Date: Jan 2019
Posts: 8
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