S,

If I do not want to use Outlook, why would you assume I want a MicroSuck product? Especially one that mandates an existing connection to a MicroSuck Network?

Email existed 20 years before MicroSuck knew or cared about it and in the real computing world, so they are alway behind the innovations that are leading edge in email. So why would I want to go to a lagging edge technology instead of leading edge?

I want an SMTP solution that is MicroSuck free, even though it resides within an Excel SS, yes contradictory isn't it. But customer needs it, but will deploy to field laptops which do not have Outlook or Exchange, especially in the field on only WiFi connections.

Sometimes we have to look past our immediate response and look at the real problem, which is neither of the tools you mentioned are available to us for this solution.

Thanks!

OMR

How can I send emails using diferent outboxes with a macro, the only solution I found was to enter outlook and change the default account. (outlook-Excel)

All,

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.

Cheers!

OMR

Hi,

I have a need to do this and I use a product called Automailer XL by DuoData. It automatically checks if a particular folder contains a file and then sends it to the user's email in a CSV file called Rcpts.csv. It works very well. You just copy what you want to send to the send folder, change the contents of Rcpts.csv and the fire up the automailer and off it goes. Been running seamlessly for about 6 years now!

Pavesa

Yes. However, you can do this programattically.

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)