>I need to be able to automate the process of sending data in a mail message thru our MSMail e-mail system.
>
>For Example, if I have cmdUpdate on my form, the user could click on that button in order to send updated data to the intended recipients.

Two ways that I know are to

1) Use WWIPSTUFF from www.west-wind.com. Send mail without using active x
2) Use the Msmapi control (should be on your system)

I have used both methods and both are very easy to set up (free too).