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.