Re: can't get each record to print separately

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Look at the information on fellow MVP Graham Mayor's website for which Peter gave you the link. It contains step by step instructions on what to do with the code.

--
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, originally posted via msnews.microsoft.com
"Kathleen" <Kathleen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:AEFD7AC8-2F49-420B-A9FE-A2ABF86E85FB@xxxxxxxxxxxxxxxx
Hi Doug/Peter,

Sorry I didn't give the Word version I'm using. Its 2003. I went through
"edit individual documents" and have saved to a new name. No section breaks
entered. I haven't set up a macro in years and am having trouble figuring
out what information to put where. I'll read through the link in the
previous post to learn more. Peter, thanks for giving it.

Doug, your macro will save me from much physical therapy. Today's merge was
a rush so it had to be done manually from the main merge document using the
preview portion to print each record. Only had to do click on print 155
times. :) With your help, tomorrow's will be much easier.

Thank you both for all your help and patience.

Kathleen

"Doug Robbins - Word MVP" wrote:

As Peter said, do NOT add any section breaks to the mail merge main
document.

You have not told us what version of Word you are using, which makes it a
bit hard to tell you exactly what commands to execute, but you must execute
the merge to a new document. If you are using the mail merge wizard, the
misleading description of that command is something like Edit Individual
Documents.

If you are using a version of Word before 2007, from the View menu, select
Toolbars and check the Mail Merge item. That toolbar contains buttons for
all of the actions that are required to crate and execute a mail merge and
towards the right hand end of the toolbar there are a series of buttons of
which there is one for each of the destinations to which the merge can be
executed.

In Word 2007, if you click on the Finish & Merge pulldown in the Finish
section of the Mailings tab of the Ribbon, select the Edit Individual
Documents button.

When you execute the merge to a new document, the document that appears will
contains all 155 of the five page letters with each one separated by a
Section Break that is inserted automatically as part of the merge execution.

With that document as the active document, running the macro that I had
written will send each of those letters to the printer as a separate print
job.

--
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, originally posted via msnews.microsoft.com
"Kathleen" <Kathleen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2CFFD1A2-2B4B-4E9C-9A06-FAF67F84C642@xxxxxxxxxxxxxxxx
> Hi Peter,
>
> I'm in the merge set up and have inserted a section break to new page.
> Now
> it gives me a blank page prior to the new record. Is that correct? > I'm
> not
> sure I understand the "print each section" from new document means.
>
> Kathleen
>
> "Peter Jamieson" wrote:
>
>> It can be impossible to get this right if your printer drivers do not >> do
>> the
>> right thing. The problem is that Word sends the output for a merge as >> a
>> single print job, and in some cases the printer does not honour the
>> different page types.
>>
>> What Doug is suggesting is:
>> a. merge to a new document rather than directly to the printer
>> b. print each Word Section as a separate print job. Unless you have a
>> section break in your mail merge main document, when Word outputs to a
>> new
>> document, each copy of your letter is in a different Word Section, so
>> this
>> way each letter is printed seperately.
>>
>> ATo see how to run this macro, see Graham Mayor's page at
>>
>> http://www.gmayor.com/installing_macro.htm
>>
>> (You'll probably need to add
>>
>> Sub printmylettters()
>>
>> at the top of DOug's code and
>>
>> End Sub
>>
>>
>> at the bottom)
>>
>> Peter Jamieson
>>
>> "Kathleen" <Kathleen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:447C2E9E-73EC-4AAF-88BB-96C2BC497BCC@xxxxxxxxxxxxxxxx
>> > Hi,
>> >
>> > I have a 155 participant mail merge that is set up with each record
>> > having
>> > 5
>> > pages. The first page prints on letterhead, the second/third on >> > memo
>> > paper
>> > and pages 3 - 5 on white paper. The print works great for the first
>> > record
>> > and then continues to use the white paper which, I think, means that
>> > the
>> > document doesn't know when a record ends. I thought page breaks >> > would
>> > work
>> > but it didn't or I didn't do it write. Looking through some of the
>> > posts
>> > there was a suggestion from Doug Robbins to use a macro but I have >> > no
>> > idea
>> > what it means.
>> >
>> > Dim i As Long
>> > With ActiveDocument
>> > For i = 1 To .Sections.Count
>> > .PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i
>> > Next i
>> > End With
>> >
>> >
>> > Is there a way to do this or is the only option to click print when
>> > viewing
>> > each record?
>> >
>> > Kathleen
>>



.

Relevant Pages

  • Re: cant get each record to print separately
    ... your macro will save me from much physical therapy. ... bit hard to tell you exactly what commands to execute, ... written will send each of those letters to the printer as a separate print ... Doug Robbins - Word MVP, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: cant get each record to print separately
    ... As Peter said, do NOT add any section breaks to the mail merge main document. ... You have not told us what version of Word you are using, which makes it a bit hard to tell you exactly what commands to execute, but you must execute the merge to a new document. ... When you execute the merge to a new document, the document that appears will contains all 155 of the five page letters with each one separated by a Section Break that is inserted automatically as part of the merge execution. ... Doug Robbins - Word MVP, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Break up Mail Merge into separate documents
    ... to execute the macro, ... the macro I made from your previous message. ... >catalog type mailmerge maindocument which creates a word ... I would like the 30 letters to save ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Mail Merge to E-mail with Attachments - help
    ... You must execute that merge to a new document. ... The macro is run when the document created by executing the merge is ... "Steve K" wrote in message ... > docuemnt type do I pick: Letters, Email, Envelopes, Lables ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Macro execution by Autotext entry
    ... Peter wrote: ... Is there any way to get an autotext entry to execute a macro? ... the pop-up to press enter, that when they do, it executes a macro. ...
    (microsoft.public.word.vba.general)