I searched my system files and I do have mapi.dlls in both my system32 and 64 folders but I suspect one needs more than just the dll to use mapi.
As I mentioned before. I didn't bother changing the email addresses since the code has never executed far enough to "send" anyway. I did change the SMTP address even though the code is never used that far either. If you have the time, I'd be VERY interested in knowing what error you get when the email address doesn't match the smtp server. It may trigger an error but my guess would not be a "Class not registered" error.
I looked closer at Thunderbird and found that it was a very old version (something like 6). Just to cover all my bases, I downloaded the current version (11) but it made no difference to the CDO execution.
I'm part of a group of artists participating in an art show and my job is to track what and for how much each artist sells at the show because we have a central checkout system and need to settle up after the end of the show. I've set up an autofilter in Excel to display each item sold by a given sales person. That being said, I can send out sales reports which are acurate only to about 12 items because I've discovered there's a limit of about 1024 characters that can be used in the variable for the message body using the ShellExecute method. Anything longer that that is abruptly truncated even in the middle of a record. The good news is that because it uses my default email app there's no need to program server addresses, ports, usernames, passwords etc. The bad news is that in addition to the limitation in the size of the message body, ShellExecute can't handle attachments. Those were the reasons that I was exploring the CDO option.
From what I've read there have been a lot of problems with Win 7 and MAPI I've found a number of people with the same issue of "Class not Found" but no definative answers as to the cause. My guess is that some lingering remnant(s) of an Outlook Express installation is crucial to the success or failue of CDO and since win7 did not come with Outlook Express, it is missing that element(s).
Thanks a lot for trying but I think I'm going to have to throw in the towel on the CDO idea. I've included total gross sales information in my email sales reports and I'll just have to print out the item lists rather than email them for those with more than a dozen items sold.
