Mail Merge Printing

Danholland · #1 01-30-2017, 08:46 AM

Hi

i have a mail merge for printing form packs which are all 6 pages each,

what i would like to be able to do it print each set so that every 6 pages would staple so that once the jobs finished ill have individual forms ready to be posted.

does anyone know a way around this without printing each set individually?

gmayor · #2 02-02-2017, 09:43 PM

If your data source is Excel, you could use http://www.gmayor.com/ManyToOne.htm in One to One mode and merge to the printer, each document is treated as a separate print job.

If not you could use the following macro. Merge to a new document and use the macro to split the document to the printer.

Code:

Sub SplitMergeLetterToPrinter()
Dim lng_Sections As Long
Dim lng_Counter As Long

    lng_Sections = ActiveDocument.Sections.Count
    lng_Counter = 1
    While lng_Counter < lng_Sections
        ActiveDocument.PrintOut Background:=False, Range:=wdPrintFromTo, _
                                From:="s" & Format(lng_Counter), to:="s" & Format(lng_Counter)
        lng_Counter = lng_Counter + 1
    Wend
lbl_Exit:
    Exit Sub
End Sub

Danholland · #3 02-03-2017, 01:49 AM

will this need changing at all, im not very good at understanding macros

Quote:

Originally Posted by gmayor

If your data source is Excel, you could use http://www.gmayor.com/ManyToOne.htm in One to One mode and merge to the printer, each document is treated as a separate print job.

If not you could use the following macro. Merge to a new document and use the macro to split the document to the printer.

Code:

Sub SplitMergeLetterToPrinter()
Dim lng_Sections As Long
Dim lng_Counter As Long

    lng_Sections = ActiveDocument.Sections.Count
    lng_Counter = 1
    While lng_Counter < lng_Sections
        ActiveDocument.PrintOut Background:=False, Range:=wdPrintFromTo, _
                                From:="s" & Format(lng_Counter), to:="s" & Format(lng_Counter)
        lng_Counter = lng_Counter + 1
    Wend
lbl_Exit:
    Exit Sub
End Sub

gmayor · #4 02-03-2017, 04:39 AM

http://www.gmayor.com/installing_macro.htm

loriwojo · #5 03-20-2018, 06:39 AM

Never mind - solved

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Printing a Mail Merge output file	Ar-Pharazon	Mail Merge	7	09-13-2014 07:11 AM
problem printing labels using mail merge	renee.g	Mail Merge	1	05-08-2013 01:33 AM
Help With Printing Mail Merge	dazwm	Mail Merge	6	04-19-2013 05:15 PM
Mail Merge Skipping 2 Labels when Printing	mbsfirst	Mail Merge	3	12-27-2010 04:28 PM
Printing problem with mail merge	irenej48	Mail Merge	0	01-01-2010 03:03 PM