Thread: How to extract specific pages (Category) or arrange pages in a mail merge document?
View Single Post
 
Old 09-18-2021, 01:51 AM
kitlwy kitlwy is offline Windows 10 Office 2019
Novice
  
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