I have a code that filters a column for unique entries. For each unique entry it will copy and paste the information into a new workbook and then it saves the file with an email address as the name. Then it should send that file as an attachment to the email address that the workbook was saved as. The code currently runs through for all unique values but will only email the first workbook. So for example if there were 6 unique values in the column, I would wind up with 6 saved files but only the first one is sent to the recipient. Any ideas on what needs to change in the code to get it to send to everyone? Any help is appreciated as I'm still fairly new to VBA.
Please Login or Register to view this content.
Bookmarks