Problem: Mail merge and have your copier staple/fold/insert special pages/etcWhen processing a merge, word creates a multi-record file and sends this as a single job to the printer. So, for example, your 2 page letter with 500 merge records appears at the printer as a 1000 page document. The printer simply sees a single file and prints it. So if you set it to staple, it will not staple every 2 pages. Also any special pages, i.e. 1st page on headed 2nd page on plain etc only work on the 1st and 2nd page of the 1000 page document, the remaining 1998 pages will print with the default job settings.
Solution: Mail Merge MacroCreate a macro with the code below, setup your requirements in printer prefs and then run the macro when you are ready to print - instead of using the usual Finish and Merge button. The macro causes word to send each merge record as a separate job to the printer, so all the finishing will work as normal. One word of warning be sure you know how to 'clear all' print jobs queued on your copier. If for any reason you need to abandon the whole print job you do not want to be lumbered with clearing 1000 jobs from the queue individually.
For some excellent MS Word tips, like creating individual files from a merge, and just about anything else you can think of check out Graham Mayor's page.
This worked so perfectly.ReplyDelete
Thank you for the Macro. You just made my day and my colleagues day a lot better.
I know this is quite old now but Thank You.ReplyDelete
thanks for information
thank you so much, this was very helpful!ReplyDelete
Speaking about document storage. I would suggest dataroom services, I know for sure all the paperwork is stored securely online.ReplyDelete
Everybody knows about PDF (Portable Document Format) records on account of the free Adobe PDF peruser program introduced on PCs. https://www.altomerge.com/faqReplyDelete
The vast majority of us can get and open PDF records fine and dandy on account of Adobe's free and well known Acrobat Reader program. w9 formReplyDelete
I'm not sure where to get the money ideal blackjack game I know a cool site where you might smile good luckReplyDelete
Technology reconciliation techniques for substance guidelines. Starting in kindergarten and stretching out through evaluation 12, different advancements can be made a piece of ordinary educating and realizing diebestenvpnReplyDelete
Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained! View moreReplyDelete