I have developed some VBA code that worked great in excel 97, allowing me to creat workbooks (summarized from a master workbook) and automatically send them to the proper recipiant through outlook.
Since I have upgraded to excel2000 w/outlook2000, when the code goes to “send” the workbook, I get a message asking me to confirm that I want to do that. How can I eliminate this dialog box?