X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Mso Word 2016 - Vba To Print Each Document Of A Mail Merge As A Seperate Print Job., Office 2013    
post Mar 7 2019, 01:52 PM

Posts: 439
Joined: 11-March 15
From: Somewhere lost in the NY Subways

I am working on a project which I am creating prefilled forms and using our printer's booklet mode to take the 4 pages that are 8.5x11 and put them on to 11x17 so that we can make a booklet looking presentation.

My problem is that when I send my full mail merge to the printer it treats it as one big document instead of each merge record being a separate document.

Is there a way to send each merge request as a separate job with out having to do it manually?

Go to the top of the page
post Mar 7 2019, 02:01 PM

UtterAccess VIP
Posts: 7,258
Joined: 30-June 11

One thing I've done is generate/save each merge separately in a given folder and then loop through the files in that folder invoking the print command.

You may also find the following useful, http://www.gmayor.com/individual_merge_letters.htm

Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc

All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
post Mar 8 2019, 12:07 AM

Posts: 439
Joined: 11-March 15
From: Somewhere lost in the NY Subways

Hi all...

I just saw the reply. I just wanted to update that I used Doug Robbins; Merge Tools to get it to work
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    4th April 2020 - 06:47 PM