How to extract specific pages (Category) or arrange pages in a mail merge document?

kitlwy · #5 09-20-2021, 07:34 AM

Quote:

Originally Posted by Guessed

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.

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
Skip Pages in a Mail Merge	Chris Morris	Mail Merge	2	06-02-2016 05:46 AM
Advanced page numbering: section pages in header, document pages in footer	Albus	Word	12	12-12-2014 01:36 PM
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