Access 2000: Mail functions

[johndoomed]

Hi! I’m hoping for your help on this one!

I’m running a small web-hosting service, and my password-database is in Access 2000. I have trouble making to functions, both e-mail functions:

1. Send e-mail with password
A function that sends one mail to a single e-mail address containing a password. Based on a form or query.

2. Start outlook and export mail address
Just like the HTML code MAILTO:adress. I can’t figure out how to get this to work. The address is a variable. Get the value from the form or a query.

First of all, which technique should I use? Macro or script? Second, how do I use it?

Thanks for any help!

 

[reclusivemonkey]

Use VBA in a module, and use the SendObject command.