Mail merged printing and duplexing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mrodriguez79 - 23 Mar 2007 17:52 GMT

Here's what I'm trying to do. I need to print out 50 reports that will be on
11"x17" paper and my duplexer will staple and fold them automatically.

Here's the problem: when I mail merged the reports to personalize them and
then sent them to the printer, it seems like it is sending all of the reports
together as one big file instead of 50 individual files. So my
printer/duplexer is trying to make one big report instead of 50 smaller ones,
which obviously will not work.

I think there has to be some type of setting that would take care of this,
but I can't seem to figure it out. Please help!

Thanks,

Mario

Reply to this Message

Doug Robbins - Word MVP - 24 Mar 2007 00:07 GMT

You will need to execute the mailmerge to a new document and then use the
following macro to send that document to the printer:

Dim i As Long
With ActiveDocument
For i = 1 To .Sections.Count
.PrintOut Background:=False, Range:=wdPrintFromTo, From:="s" & i,
To:="s" & i
Next i
End With

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Here's what I'm trying to do. I need to print out 50 reports that will be
> on
[quoted text clipped - 15 lines]
>
> Mario

Reply to this Message

mrodriguez79 - 26 Mar 2007 16:09 GMT

Thanks, Doug. Will try it out!

>You will need to execute the mailmerge to a new document and then use the
>following macro to send that document to the printer:
[quoted text clipped - 12 lines]
>>
>> Mario

Reply to this Message

mrodriguez79 - 29 Mar 2007 22:03 GMT

Doug, I'm a complete newbie in dealing with macros... so this is going to
sound crazy...

How do I create and execute a macro?

>You will need to execute the mailmerge to a new document and then use the
>following macro to send that document to the printer:
[quoted text clipped - 12 lines]
>>
>> Mario

Reply to this Message

Doug Robbins - Word MVP - 30 Mar 2007 05:49 GMT

See the article "What do I do with macros sent to me by other newsgroup
readers to help me out?" at:

http://www.word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Doug, I'm a complete newbie in dealing with macros... so this is going to
> sound crazy...
[quoted text clipped - 18 lines]
>>>
>>> Mario

Reply to this Message

mrodriguez79 - 30 Mar 2007 17:58 GMT

Thanks for your time and help, Doug! I really appreciate it!

Mario

>See the article "What do I do with macros sent to me by other newsgroup
>readers to help me out?" at:
[quoted text clipped - 6 lines]
>>>>
>>>> Mario

Reply to this Message

Rate this thread: