Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-18-2021, 01:51 AM
kitlwy kitlwy is offline How to extract specific pages (Category) or arrange pages in a mail merge document? Windows 10 How to extract specific pages (Category) or arrange pages in a mail merge document? Office 2019
Novice
How to extract specific pages (Category) or arrange pages in a mail merge document?
 
Join Date: Sep 2021
Posts: 4
kitlwy is on a distinguished road
Smile How to extract specific pages (Category) or arrange pages in a mail merge document?

Hi, I am new to this forum and I have searched through the page but I am not sure how I can get what I want. So I m opening this post looking for help.

I have a 5 pages documents with workers' information for taking their attendance throughout a week.

Page 1: Company A Workers
Page 2: Company B Workers (p.1)
Page 3: Company B Workers (p.2)
Page 4: Company C Workers
Page 5: Company D Workers

The excel file is simply showing the date in a week.
13/9/2021
14/9/2021
15/9/2021
16/9/2021
17/9/2021
18/9/2021

Merge mail works in generating a document in below order:
Page 1: Company A Workers with date 13/9/2021
Page 2: Company B Workers with date 13/9/2021 (p.1)
Page 3: Company B Workers with date 13/9/2021 (p.2)
Page 4: Company C Workers with date 13/9/2021
Page 5: Company D Workers with date 13/9/2021
Page 6: Company A Workers with date 14/9/2021
Page 7: Company B Workers with date 14/9/2021 (p.1)
Page 8: Company B Workers with date 14/9/2021 (p.2)
Page 9: Company C Workers with date 14/9/2021
Page 10: Company D Workers with date 14/9/2021
Page 11: Company A Workers with date 15/9/2021
Page 12: Company B Workers with date 15/9/2021 (p.1)
Page 13: Company B Workers with date 15/9/2021 (p.2)
Page 14: Company C Workers with date 15/9/2021
Page 15: Company D Workers with date 15/9/2021
and so on.

However, How can I generate a document, or simply just print the document in order below?
Page 1: Company A Workers with date 13/9/2021
Page 2: Company A Workers with date 14/9/2021
Page 3: Company A Workers with date 15/9/2021
Page 4: Company A Workers with date 16/9/2021
Page 5: Company A Workers with date 17/9/2021
Page 6: Company A Workers with date 18/9/2021
Page 7: Company B Workers with date 13/9/2021 (p.1)
Page 8: Company B Workers with date 14/9/2021 (p.1)
Page 9: Company B Workers with date 15/9/2021 (p.1)
Page 10: Company B Workers with date 16/9/2021 (p.1)
Page 11: Company B Workers with date 17/9/2021 (p.1)
Page 12: Company B Workers with date 18/9/2021 (p.1)
Page 13: Company B Workers with date 13/9/2021 (p.2)


Page 14: Company B Workers with date 14/9/2021 (p.2)
Page 15: Company B Workers with date 15/9/2021 (p.2)
Page 16: Company B Workers with date 16/9/2021 (p.2)
Page 17: Company B Workers with date 17/9/2021 (p.2)
Page 18: Company B Workers with date 18/9/2021 (p.2)
Page 19: Company C Workers with date 13/9/2021
Page 20: Company C Workers with date 14/9/2021
Page 21: Company C Workers with date 15/9/2021
Page 22: Company C Workers with date 16/9/2021
Page 23: Company C Workers with date 17/9/2021
Page 24: Company C Workers with date 18/9/2021
Page 25: Company D Workers with date 13/9/2021
Page 26: Company D Workers with date 14/9/2021
Page 27: Company D Workers with date 15/9/2021
Page 28: Company D Workers with date 16/9/2021
Page 29: Company D Workers with date 17/9/2021
Page 30: Company D Workers with date 18/9/2021

OR

Page 1: Company A Workers with date 13/9/2021
Page 2: Company A Workers with date 14/9/2021
Page 3: Company A Workers with date 15/9/2021
Page 4: Company A Workers with date 16/9/2021
Page 5: Company A Workers with date 17/9/2021
Page 6: Company A Workers with date 18/9/2021
Page 7: Company B Workers with date 13/9/2021 (p.1)
Page 8: Company B Workers with date 13/9/2021 (p.2)
Page 9: Company B Workers with date 14/9/2021 (p.1)
Page 10: Company B Workers with date 14/9/2021 (p.2)
Page 11: Company B Workers with date 15/9/2021 (p.1)
Page 12: Company B Workers with date 15/9/2021 (p.2)
Page 13: Company B Workers with date 16/9/2021 (p.1)
Page 14: Company B Workers with date 16/9/2021 (p.2)
Page 15: Company B Workers with date 17/9/2021 (p.1)
Page 16: Company B Workers with date 17/9/2021 (p.2)
Page 17: Company B Workers with date 18/9/2021 (p.1)
Page 18: Company B Workers with date 18/9/2021 (p.2)
Page 19: Company C Workers with date 13/9/2021
Page 20: Company C Workers with date 14/9/2021
Page 21: Company C Workers with date 15/9/2021
Page 22: Company C Workers with date 16/9/2021
Page 23: Company C Workers with date 17/9/2021
Page 24: Company C Workers with date 18/9/2021
Page 25: Company D Workers with date 13/9/2021
Page 26: Company D Workers with date 14/9/2021
Page 27: Company D Workers with date 15/9/2021
Page 28: Company D Workers with date 16/9/2021
Page 29: Company D Workers with date 17/9/2021
Page 30: Company D Workers with date 18/9/2021


Please help me
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Attempting to mail merge one list into a document containing 3 pages - each page needs the same list LisaRH Mail Merge 3 08-09-2018 03:01 PM
How to extract specific pages (Category) or arrange pages in a mail merge document? Skip Pages in a Mail Merge Chris Morris Mail Merge 2 06-02-2016 05:46 AM
How to extract specific pages (Category) or arrange pages in a mail merge document? Advanced page numbering: section pages in header, document pages in footer Albus Word 12 12-12-2014 01:36 PM
How to extract specific pages (Category) or arrange pages in a mail merge document? Inserting pages at the end of a mail merge morten_lysgaard Mail Merge 3 07-25-2011 11:19 PM
delete blank pages from mail merge document blusea Word 0 12-17-2010 06:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft