dave26ny
09-07-2005, 07:10 PM
Hello, I have a project due at work and have no idea where to start. Basically, I have an Excel workbook with about 50 tabs. Each tab has a different vendor number for it's tab name. Each tab needs to be made into its own workbook (which i can do through vba code) however it then needs to be emailed to that specific vendor contact. I dont want to hardcode the vendor email address into the vba code, since the email addresses change frequently. Rather, we maintain another Excel file that has two columns, one for the vendor number and one for the vendor email address. I was hoping that this file could somehow be used.
Right now I have code to open up the main spreadsheet, go through each of the 50 tabs and create 50 separate workbooks (one for each vendor) and auto-save each with the vendor number as the file number.
After that i am stuck as to how to use the email distribution list to send these files automatically. Any help anyone could give me is greatly appreciated. I have samples of the files if needed. Thanks so much, Dave.
Right now I have code to open up the main spreadsheet, go through each of the 50 tabs and create 50 separate workbooks (one for each vendor) and auto-save each with the vendor number as the file number.
After that i am stuck as to how to use the email distribution list to send these files automatically. Any help anyone could give me is greatly appreciated. I have samples of the files if needed. Thanks so much, Dave.