OK, I guess I've stumped everyone. I would still like to get this macro working again so I'll put the code up (you asked for it!). Since this post I threw together another spreadsheet that does nothing bu email all our reports. The code is directly out of what you see below. The only real difference is the new macro isn't building a workbooks while emailing.
I double checked and I do not have any Outlook libraries turned on. But everything works (in the my revised macro anyway). But like I said, I would really like to resolve the issue this code seems to have.
The code to email begins around line number 620. This is one of the few routines I used line numbers on because I expected to have problems with it. So With line numbers it will tell me the line the error occured. But with an Automation Error that is not the case!
Any help would be appreciated.
Bookmarks