Reply
 
Thread Tools Display Modes
  #1   Report Post  
amie
 
Posts: n/a
Default mail merge complicated

I HAVE A MULTIPAGE & MULTISECTION DOCUMENT("DOCUMENT2") WHICH NEEDS TO BE
STAPLED AND DUPLEXED. I NEED TO BE ABLE TO PRINT A PAGE FROM ANOTHER MERGE
DOCUMENT("DOCUMENT1") BEFORE DOCUMENT2. IN OTHER WORDS FOR EACH RECORD,
DOCUMENT1 WILL PRINT AND THEN DOCUMENT2(WHICH IS DUPLEXED AND STAPLED). I
MUST MERGE DOCUMENT2 INTO A NEW DOCUMENT IN ORDER TO BE ABLE TO STAPLE THE
PAGES TO EACH RECORD SEPERATELY. I AM USING VB TO RUN DOCUMENT2
Dim i As Long
With ActiveDocument
For i = 1 To .Sections.Count Step 6
.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i + 5
Next i
End With

OPTIONA)IS IT POSSIBLE TO INSERT A COMMAND INTO THIS VB COMMAND OF DOCUMENT2
TO PRINT DOCUMENT1?
OPTIONB)OR SHOULD I COPY AND PASTE DOCUMENT1 INTO DOCUMENT2 AND MERGE
TOGETHER TO A NEW DOCUMENT(THE DATABASE IS
THE SAME FOR BOTH), HOWEVER, IF I DO THIS, WOULD THE PRINTER BE ABLE TO
PRINT PAGE1 APART FROM THE OTHER PAGES THAT NEED TO BE DUPLEXED AND STAPLED?
OPTIONC)IF THERE ISN'T A WAY TO DO THIS, HOW ABOUT PREPRINTING DOCUMENT1 AND
ASKING THE PRINTER TO
PRINT A SEPERATOR SHEET(WHICH IS USUALLY A BLANK SHEET THAT PRINTS BETWEEN
SPOOLS). OF COURSE I RUN INTO THE PROBLEM OF GETTING THEM OUT OF ORDER IF
THE PRINTER JAMS.
I PREFER OPTIONA BUT WILL USE WHICHEVER WORKS? CAN SOMEONE HELP ME CREATE A
VB COMMAND IN ORDER TO DO THIS?

  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

Please don't SHOUT!

If you do not need documents 1 and 2 stapled together, I am almost certain
that you are going to have to print the documents separately and then
manually collate documents 1 and 2.

--
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" wrote in message
...
I HAVE A MULTIPAGE & MULTISECTION DOCUMENT("DOCUMENT2") WHICH NEEDS TO BE
STAPLED AND DUPLEXED. I NEED TO BE ABLE TO PRINT A PAGE FROM ANOTHER MERGE
DOCUMENT("DOCUMENT1") BEFORE DOCUMENT2. IN OTHER WORDS FOR EACH RECORD,
DOCUMENT1 WILL PRINT AND THEN DOCUMENT2(WHICH IS DUPLEXED AND STAPLED). I
MUST MERGE DOCUMENT2 INTO A NEW DOCUMENT IN ORDER TO BE ABLE TO STAPLE THE
PAGES TO EACH RECORD SEPERATELY. I AM USING VB TO RUN DOCUMENT2
Dim i As Long
With ActiveDocument
For i = 1 To .Sections.Count Step 6
.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i + 5
Next i
End With

OPTIONA)IS IT POSSIBLE TO INSERT A COMMAND INTO THIS VB COMMAND OF
DOCUMENT2
TO PRINT DOCUMENT1?
OPTIONB)OR SHOULD I COPY AND PASTE DOCUMENT1 INTO DOCUMENT2 AND MERGE
TOGETHER TO A NEW DOCUMENT(THE DATABASE IS
THE SAME FOR BOTH), HOWEVER, IF I DO THIS, WOULD THE PRINTER BE ABLE TO
PRINT PAGE1 APART FROM THE OTHER PAGES THAT NEED TO BE DUPLEXED AND
STAPLED?
OPTIONC)IF THERE ISN'T A WAY TO DO THIS, HOW ABOUT PREPRINTING DOCUMENT1
AND
ASKING THE PRINTER TO
PRINT A SEPERATOR SHEET(WHICH IS USUALLY A BLANK SHEET THAT PRINTS BETWEEN
SPOOLS). OF COURSE I RUN INTO THE PROBLEM OF GETTING THEM OUT OF ORDER IF
THE PRINTER JAMS.
I PREFER OPTIONA BUT WILL USE WHICHEVER WORKS? CAN SOMEONE HELP ME CREATE
A
VB COMMAND IN ORDER TO DO THIS?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge - Parameter prompts twice... TL Mailmerge 6 June 17th 05 02:58 PM
Complicated mail merge with html coding [email protected] New Users 1 April 24th 05 11:55 AM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM
Word-Excel 2003 - Mail Merge Recipients problem AYager Mailmerge 2 January 11th 05 04:11 AM


All times are GMT +1. The time now is 11:57 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"