I am using Office 2010. Our payslip comes in a word document and I usually print out and deliver to each staff. Each page has each employee's payslip. However, I want a macro or VB script that can extract and email payslips according to a list of selected employees. The list can be on a different word or excel file. Each employee's unique file number can be used to search and locate the payslip within the document and then extract and sent as an email attachment.
Is this possible? Please help.