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.

closed as too broad by Matthew Williams, Excellll, DavidPostill, Nifle, Dave Nov 28 '14 at 9:57

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • This sounds like an opportunity for a disaster! You could end up emailing the wrong person! If I were you, I'd read up on VBa as you will need to test this fully and fix it if you find a bug. Any way, you need to show what you've tried as it reads as if you want some one to do your work, hence it is closed – Dave Nov 28 '14 at 9:55