Re: multiple page doc

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

There is not reason that the macro would start printing from Record 9.

--
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
"amie" <amie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:29DA958B-EFCB-45C4-A052-CE74D2F961FB@xxxxxxxxxxxxxxxx
> Dim i As Long
> With ActiveDocument
> For i = 1 To .Sections.Count Step 7
> .PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i +6
> Next i
> End With
>
> my word doc has 7 sections
>
> "Doug Robbins" wrote:
>
>> Re 1, copy and paste the code of the macro that you are trying to use
>> into a
>> message that you post back here.
>>
>> Re 2, you would be far better off to fix this problem at the source (in
>> the
>> mailmerge main document) by changing the margin setting so that the error
>> message is not received.
>>
>> --
>> 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
>> "amie" <amie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:7E8279E4-2A88-430D-A5F4-BA3465F686C0@xxxxxxxxxxxxxxxx
>> > thanks so much for your time and wisdom...
>> > now i'm encountering 2 problems that i hope visual basic can help me
>> > with.
>> > 1) after i merge to new document and run visual basic. it starts to
>> > print
>> > the merge in the middle of the list like around record 9 each time? how
>> > do
>> > i
>> > get it to spool from the beginning like it should?
>> >
>> > 2) i get an error twice about the sections going outside of the
>> > printable
>> > area. i have to click yes to print twice for each record. is there
>> > anyway
>> > to
>> > get visual basic to enter twice for me? or is there any other means by
>> > which
>> > i can get rid of this annoying error?
>> >
>> > "Doug Robbins" wrote:
>> >
>> >> I have answered your later post.
>> >>
>> >> --
>> >> 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
>> >> "amie" <amie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:30F4B6A6-3AAD-4F7C-A474-F97ADFE9099A@xxxxxxxxxxxxxxxx
>> >> > Hi, I have taken this over this project. I believe this isn't
>> >> > working
>> >> > for
>> >> > us
>> >> > because our original mail merge doc contains multiple sections. i
>> >> > have
>> >> > tried
>> >> > to delete these but that seems to corrupt the formatting of the doc.
>> >> > i
>> >> > need
>> >> > to be able to staple this multipage doc. i have been reading the
>> >> > visual
>> >> > basic
>> >> > help. i have some ideas. is there a way to specify to staple range
>> >> > of x
>> >> > amount of pages once i have merged to a new doc. or is there a way
>> >> > to
>> >> > insert
>> >> > break at the end of the original doc before i merge records to new
>> >> > document?
>> >> >
>> >> > "Doug Robbins" wrote:
>> >> >
>> >> >> Execute the merge to a new document and then run a macro containing
>> >> >> the
>> >> >> following code when that document is the active document and it
>> >> >> will
>> >> >> send
>> >> >> the 7 pages for each record to the printer as a separate print job
>> >> >> so
>> >> >> that
>> >> >> they will be stapled individually:
>> >> >>
>> >> >> 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
>> >> >>
>> >> >>
>> >> >>
>> >> >> --
>> >> >> 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
>> >> >> "Debi" <Debi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> >> news:34CA4311-6182-4F61-B959-488D59933A4B@xxxxxxxxxxxxxxxx
>> >> >> > We have a multiple page duplexed word do that is a Mail Merge doc
>> >> >> > also.
>> >> >> > It
>> >> >> > is 14 pages, 7 duplexed. We need to have it staple the 7 pages
>> >> >> > for
>> >> >> > each
>> >> >> > record in the Merged excel file. But it staples all together.
>> >> >> > How
>> >> >> > can
>> >> >> > we
>> >> >> > get it to just staple the 7 pages per record?
>> >> >> > --
>> >> >> > dm
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>


.

Relevant Pages

  • Re: text file for mail merge stumped
    ... Please reply to the newsgroup unless you wish to avail yourself of my ... Doug Robbins - Word MVP ... Here is my last attempt at macro recording. ... When bringing data in it does not reconize comma ...
    (microsoft.public.word.vba.beginners)
  • Re: VBA Word 2003 File Close
    ... Earlier to day I created the following code to help someone in the mailmerge.fields newsgroup overcome a problem with documents that he was inserting into another document were losing their margin settings. ... You will not that it uses Source.Close wdDoNotSaveChanges and that does not cause an error. ... Doug Robbins - Word MVP, ... It is very weird because the Macro runs fine if I just use F5. ...
    (microsoft.public.word.vba.general)
  • Re: Email Attachment in Word 2003 Mail Merge
    ... Where you are choosing Email as the type of main document, ... Please reply to the newsgroup unless you wish to avail yourself of my ... Doug Robbins - Word MVP, ... but I still have the same message on running the macro. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Attach macro to a picture
    ... Attaching the macro makes it invisible if the ... Please reply to the newsgroup unless you wish to avail yourself of my ... Doug Robbins - Word MVP, ... it disappears when the field codes are not shown. ...
    (microsoft.public.word.vba.general)
  • Re: How to remove automatically some pages?
    ... Word MVP web site http://word.mvps.org ... separately without the extra character. ... I used the macro to the big MailMerge output file and it ...
    (microsoft.public.word.newusers)