#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
Since you haven't posted any code, it's impossible for anyone here to tell what the issue is. That said, see:
• Split Merged Output to Separate Documents; and, better still • Send Mailmerge Output to Individual Files, in the Mailmerge Tips and Tricks 'Sticky' thread at the top of the mailmerge forum: Mailmerge Tips & Tricks
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
Quote:
Code:
DoEvents 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 |
Tags |
word;maiimerge;vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge does not split tables if entry has a number in front | B-Man | Mail Merge | 5 | 05-19-2019 07:25 AM |
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 |
Split each page of mail merge into separate pdf | Declan | Mail Merge | 1 | 05-28-2014 02:02 AM |
Automatically split Mail Merge based on number of pages | SaneMan | Mail Merge | 1 | 12-03-2011 01:11 AM |