You all are really stuck on this Window crap. Unbuntu Linux has over 2x distros as Windows and combined Linux world has over 3x OS copies out working.
All these are on Open Office which will open Excel and run the macros. Obviously since on Lunix OS, will not have access to any MicroSuck code, api's, etc.
On Linux side this is rather simple as "SENDMAIL" is a native OS level command, but not so in Windows. The Excel VBA I am writing must be platform independent.
I'm not dissing 3/4 of the potential world-wide customers in favor of the greatly inferior Windows OS.
So back to the problem. For the windows side I found the Outlook & MS independent osSMTP.dll package that I think I can use to create the code, which contains a "SENDMAIL" command.
I'm now looking into the surrounding or supporting parms to see what the differences are between Windows vs Linux, so I can query the system for platform and massage the parms and text with the email accordingly.
Take a look at the osSMTP package. It is definitely a thinner client, not hogging memory or causing any of the errors that the MS-OS interlaced Outlook or MS APIs are routinely guilty of.
Last edited by OldManRiver; December 11th, 2009 at 11:33 AM..