Hi Movain,

I would suggest you use the php solution. It is much more secure. The problem with the VBA solution is Vista doesn't play nice with ODBC without some tweaking, the last time I tried to do something with it, so it more than likely has changed since then. (I would hope anyway) The "Preferred" way is NOW CDO. Tomorrow it will be BMA. LOL

The best part is you can still make a development machine and have all of the stuff setup to work seamlessly before going live. Just remember to remove your test data before going live so you don't embarrass you or somebody else. (No I have not ever done that in any shape form or fashion!)