Hey, ho... We just published a new article, Sending Custom Email. It's actually a reprint of an article on the companion CD of Jim Buyens' book, "FrontPage 2003 Inside Out" published by MS Press.
This article, the four reprint from Jim's book, shows how to use classic ASP to send custom email from a FrontPage form. From the introduction:
The Microsoft Office FrontPage 2003 Save Results component does an adequate job of sending the contents of a form as an e-mail message, but it's not flexible enough to handle all situations. You can't, for example, format the message exactly to your liking, and you can't send e-mail messages to different recipients depending on the circumstances. If you have these kinds of requirements, you'll need to locate other tools and do some custom coding.