Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 09-19-2021, 05:03 PM
Guessed's Avatar
Guessed Guessed is online now 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 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 2,720
Guessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to behold
Default

Have you used the Edit Recipient List and then specified the sort order on the two fields (Company then Date)?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 09-19-2021, 11:44 PM
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
Default

Quote:
Originally Posted by Guessed View Post
Have you used the Edit Recipient List and then specified the sort order on the two fields (Company then Date)?
It only makes the output document having blank information....
Reply With Quote
  #4  
Old 09-19-2021, 11:50 PM
Guessed's Avatar
Guessed Guessed is online now 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 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 2,720
Guessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to behold
Default

Then perhaps you need to post your sample data and merge document so we can see what you are doing. Sorting the data shouldn't remove records - but filtering it might.

An alternative might be to link the Excel data into an Access Database and create a report that shows the data in the format you want it.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 09-20-2021, 07:34 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
Default

Quote:
Originally Posted by Guessed View Post
Then perhaps you need to post your sample data and merge document so we can see what you are doing. Sorting the data shouldn't remove records - but filtering it might.

An alternative might be to link the Excel data into an Access Database and create a report that shows the data in the format you want it.

So the attached files are the samples.
1. Company Attendance Record.docx --> 6 pages word document processing mail merge with different names on each pages
2. Date List showing the date of a week I want to appear in the attendance sheet
3. Output is how the file turned out
4 & 5 is what I want, separating each company to a different files OR in order such as Company A (19/9/2021)
Company A (20/9/2021)
Company A (21/9/2021)
Company A (22/9/2021)
Company A (23/9/2021)
Company A (24/9/2021)
Company B (19/9/2021)
Company B (19/9/2021)
Company B (20/9/2021)
Company B (20/9/2021)
Company B (21/9/2021)
Company B (21/9/2021)
Company B (22/9/2021)
Company B (22/9/2021)
Company B (23/9/2021)
Company B (23/9/2021)
Company B (24/9/2021)
Company B (24/9/2021)
Company C (19/9/2021)
Company C (20/9/2021)
Company C (21/9/2021)
Company C (22/9/2021)
Company C (23/9/2021)
Company C (24/9/2021)
...and so on

Please help.
Attached Files
File Type: docx Company Attendance Record.docx (20.8 KB, 2 views)
File Type: xlsx Date List.xlsx (10.1 KB, 3 views)
File Type: pdf Output.pdf (326.6 KB, 2 views)
File Type: pdf Company A (wanted).pdf (84.3 KB, 1 views)
File Type: pdf Company B p.1 (wanted).pdf (84.5 KB, 1 views)
Reply With Quote
  #6  
Old 09-20-2021, 05:00 PM
Guessed's Avatar
Guessed Guessed is online now 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 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 2,720
Guessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to behold
Default

Your date list doesn't have a column for employee names. Does that mean the list of employees is static?

The Date List contains duplicate records. Should they be ignored or do you want a sheet for each record

Is the colour of the names in your output documents pertinent to what you want? If so, what does the colour mean?

It appears to me that the simplest solution for this is to use Microsoft Access. Is there a reason you are trying to do this with Word?

Finally, if staying in Word, I would suggest you work through the tutorial pinned at the top of this forum https://www.msofficeforums.com/mail-...-tutorial.html as this looks like it aligns reasonably closely with what you are trying to do.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 09-30-2021, 01:55 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
Default

1. Your date list doesn't have a column for employee names. Does that mean the list of employees is static? <-------Yes. The list of employees is static.

2. The Date List contains duplicate records. Should they be ignored or do you want a sheet for each record <-------- I want a sheet for each record.

3. Is the colour of the names in your output documents pertinent to what you want? If so, what does the colour mean?<-------The colour has no meaning.

4. It appears to me that the simplest solution for this is to use Microsoft Access. Is there a reason you are trying to do this with Word?<-------I don't know how it works.




Quote:
Originally Posted by Guessed View Post
Your date list doesn't have a column for employee names. Does that mean the list of employees is static?

The Date List contains duplicate records. Should they be ignored or do you want a sheet for each record

Is the colour of the names in your output documents pertinent to what you want? If so, what does the colour mean?

It appears to me that the simplest solution for this is to use Microsoft Access. Is there a reason you are trying to do this with Word?

Finally, if staying in Word, I would suggest you work through the tutorial pinned at the top of this forum https://www.msofficeforums.com/mail-...-tutorial.html as this looks like it aligns reasonably closely with what you are trying to do.
Reply With Quote
  #8  
Old 09-30-2021, 04:50 AM
Guessed's Avatar
Guessed Guessed is online now 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 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 2,720
Guessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to behold
Default

If you want to do this with a mail merge then I would create a separate source document for each company and have a single merge field containing a series of dates. The data source would just contain incrementing dates like
20/9/2021
21/9/2021
22/9/2021
23/9/2021
24/9/2021

The more labour intensive (to create) method would be to devise a macro which asks for start and finish dates and prints out the relevant pages without using a merge source at all.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


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 02:11 PM.


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