I have a table with around 50,000 rows that contains details for many different employees. Each employee has one or more rows of information and for each employee, I would like to save the table (with their records only) into a new workbook, and then email that workbook to the employee (using Outlook 2016).
The table runs from col A to X, with the employee name being in col D and the employee email being in col L.
Is this possible? Any help would be greatly appreciated.
Many Thanks
Bookmarks