Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
COURSE of the MONTH
14 days, 13 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How do I force new pages for each chapter in a MS Word "directory" merge?
Posted on 2016-09-26
I have 2000 questions that I am publishing into a book. The questions are from various chapters (1 to 330) and I would like each chapter to appear at the top of the page, such as "Chapter 100" when advancing to the next chapter. Can this be done in MS Word? How about MS Publisher, instead of Word? Or are there third party programs that can be purchased?
I know I can manually go through the final document and add in page breaks and chapter headings, but this will take too much time.
THank you.
I know I can manually go through the final document and add in page breaks and chapter headings, but this will take too much time.
THank you.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
3
8 Comments
Active today
There must be something that separates one chapter from the next. Suggest: do a search-and-replace and apply the paragraph page break (Format option, in the version I have) as part of the change.
I have 2000 questions. each question has a chapter number in one of the data fields. When the chapter number is different from the previous chapter number, that is when I want the heading to be displayed.
Active today
You can use a Wildcard Find and Replace
Find: ^13(Chapter [0-9]{1,}^13)
Replace: ^p^m\1
Find: ^13(Chapter [0-9]{1,}^13)
Replace: ^p^m\1
Active today
Sorry. I cross-posted and didn't see your new requirement. Can you post a sample document, please?
The datafile has 200 records. Let's say that the first 15 records have a "1" in the chapter field. Records 16 through 28 have a "2" in the chapter field. Records 29 through 40 have a "3", etc.
I want to start a new page after record 15 with a heading "Chapter 2" on it.
I want to start a new page after record 15 with a heading "Chapter 2" on it.
Active today
There are two main ways.
Firstly you can do it during the merge using fields - perhaps a bit like this:
https://support.microsoft.com/en-us/kb/294686
Another method would be to run a VBA macro on the output document. To do this it would be necessary to extract the chapter number from the text. There are no mergefields in the merge result document. Therefore it would be necessary to find the data by the context, so it would help to see a sample output document.
Firstly you can do it during the merge using fields - perhaps a bit like this:
{ IF { MERGESEQ } = "1" "{ MERGEFIELD CITY }¶
" "" }{ SET Place1 { MERGEFIELD CITY }}¶
{ If { Place2 } <> { Place1 }"¶
{ MERGEFIELD CITY }¶
¶
{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" "{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" }{ SET Place2 { MERGEFIELD CITY }}¶
https://support.microsoft.com/en-us/kb/294686
Another method would be to run a VBA macro on the output document. To do this it would be necessary to extract the chapter number from the text. There are no mergefields in the merge result document. Therefore it would be necessary to find the data by the context, so it would help to see a sample output document.
Perfect. This took time to write, but it worked EXACTLY as I needed it to. Thank you for finding this for me.
Featured Post
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Outlook for dependable use in a very small business
This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…
- Microsoft Applications
- Windows 10
- Windows OS
- Fonts Typography
- Windows 7, Microsoft Word
Suggested Courses
Course of the Month14 days, 13 hours left to enroll
770 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.