section breaks that jump

[cramd2]

Group,
I have a document that has two sections, section 1 is the customer letter, section 2 is the customer order form. This document is printed on a legal size paper, merged with data, and then section 2 is cut from section one. The letter(section 1) has always had 46 line of text on it - now we are changing the letter so that for customer 1 the letter may have 42 lines, customer 2, may have 48 lines, all depends on the data that is merged for that particular customer. I'm having trouble with section 2, it HAS to stay at line 68, the problem is that if cust 1 has 46 lines, my section 2 jumps up. I'm using a "continuous section break". What do I need to position section 2, so that regardless of the letter size in section 1, that section 2 never moves from it's position?
cramd2

 

[TonyJollans]

It might be possible to cobble something together for this (it depends a bit on how the merge fields are defined and used) but what is so special about line 68? is it somehow relative to the page - if so, it may be possible to position it in another way.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[cramd2]

Hi Tony,
Section 1 has merge fields for name, address, etc, along with "INCLUDE TEXT" fields, that pulls data from a defined bookmark document. This is where the letter lengthens, it is determined by data that pulls in a bookmark and creates a letter for a particular customer. After the merge, there could be 10,000 documents that now go to the next department.
This stack of documents gets perforated at section 2 (the order form) from the letter (section 1). When this stack of documents are perforated, section 2 cannot jump, if it does, the perforation will not be on the correct line.
cramd2

 

[TonyJollans]

Hi cramd,

Try using an ADVANCE field - { ADVANCE \y 800 } perhaps - just before the line you want to position. The number (800 in this example) is points from the top of the page, you'll have to work out exactly where you want the line for yourself.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[fumei]

Your perforation is (or could be) in the midst of a page? A specific line? Would it not be easier to make it by page break?

Gerry

 

[cramd2]

Gerry,
Perforation is usually about 3/4 down on the page. If I do page breaks, I have two pages - I need to keep both pieces of info, (letter & order form) on one page.

I'll look into the {Advance } field option - see if that helps. I'm looking for an ANCHOR.....that would help me, but I guess there is no such feature.

cramd2

 

[fumei]

There is an Anchor for Shapes, although I don't know if that is relevant for this.

Excuse me, but I don't understand.

I need to keep both pieces of info, (letter & order form) on one page.

Uh...OK....then why the perforation? Perforations are usually separated eventually, which, hmmmmm, means they are no longer together. Or am I missing something?

Gerry

 

[cramd2]

Gerry,
The document has a perforation for the customer to tear apart if they decide place an order. The perforation only tears apart from the document if the customer chooses to do so. This is a legal size document, letter on top, then a perforation that separates the letter from the order form.
cramd2

 

[tf1]

Well it seems to me that the easiest option is to always have the customer order form on a separate page. Then there is no need for the customer to have to tear anything making it simpler for him/her and all you have to do is to start the form with a ParagraphPageBreakBefore making life simpler for you.

However, if you must make life as hard as possible, put the form in the last page footer. Then it will always be at the bottom of the last page regardless f how many pages preceed it.

Regards: tf1

 

[TonyJollans]

Personally I think the request is perfectly reasonable. Perforations aren't really the issue; they're just a special case of pre-printed stationery (even if, in this case, they're made after printing). The Advance field should do the job perfectly.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[