Dear all,
I'm trying to automate a report production and distribution process. What I need to do is create a macro that goes through the list (1 to 20) and for each row creates a new file (separate Excel file), pastes 2 tabs from the current one (sheet names are in columns J and K) and saves it under the filename in column E. Then the macro should open Outlook and create an email by attaching the file and using the subject, distribution list, email body as shown in the table.
I'd highly appreciate any help as I've been bumping my head with this for a while.
excel111.PNG
Thanks,
Alex
Bookmarks