Thread: Send e-mail from Excel VBA without Security Warning?

Hi everyone,

I am using Excel and VBA to pull and store data from a live manufacturing
process, and to automatically e-mail a warning to the production manager when
the process values drift outside allowable limits.

How do I bypass the Security warning that Excel generates? (Preferably
without reg edit). While the warning is active other Excel processes cease
and I lose the live feed to the data.

If anyone could help I would REally appreciate it.
Thanks.

Possibly using CDO. See Ron de Bruin's site:

Ron de Bruin
http://www.rondebruin.nl/sendmail.htm


--
Regards,
Tom Ogilvy

"mattinthehat" <mattinthehat@discussions.microsoft.com> wrote in message
news:D5D05554-F0D2-4FBA-8CE4-96002AC0202B@microsoft.com...
> Hi everyone,
>
> I am using Excel and VBA to pull and store data from a live manufacturing
> process, and to automatically e-mail a warning to the production manager
when
> the process values drift outside allowable limits.
>
> How do I bypass the Security warning that Excel generates? (Preferably
> without reg edit). While the warning is active other Excel processes
cease
> and I lose the live feed to the data.
>
> If anyone could help I would REally appreciate it.
> Thanks.

Me To I Want Send e-mail from Excel VBA without Security Warning

Etheer,

You should not post in other's thread as per Forum Rule No.2. Please go through the Forum Rules.

2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

Regards,
Humac