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?
|