Excel 2003/Outlook Code Does not Work in Outlook 2010

Hi,

I have an Excel VBA code developed in Excel 2003 that uses Outlook to send an email. However basd on my research, the code doesn't seem to work in Outlook 2010. This is the old code and fails in the last line regarding object not defined:

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Please Login or Register  to view this content.

Any help would be appreciated?

I'm a little surprised this ever worked at all because FnSendMailSafe is not a method of an Outlook application object. I would guess that code originated from this site, which says that it is not compatible with 2010+. The site offers an alternative but charges for it.

When you have a code problem like this, it is not always true that the problem can be solved by looking at just the few lines of code where the error pops up. You should include all of your code.