I have the same situation. I created and Excel workbook that virtually populates all the info on its own. I've created a macro that will put the book into Outlook 2000 but I still have to manually populate who it goes to.
Is it possible to create the macro and have it, upon execution, email the workbook to single person or to a group of persons wothout having to manually enter in who it goes to in the "To" field?
If anyone can help it would be greatly appreciated.
JB