Posted to microsoft.public.excel.programming
|
|
Email/CDO/VBA
Jim,
Ahah I see. You wanted the OP to confirm for himself that CDO wasn't the
answer. Very astute.
--
Regards,
Tom Ogilvy
"Jim Thomlinson" wrote:
Absolutely... I posted that link as it is everytihing you want to know about
CDO. If I said that the server restriction was an issue then that is just one
opinion. Ron's site is the authority on these matters and that site says it
better than I ever could. Not to mention I am really lazy and it's easiest to
just post a link...
Point take however. I should have mentioned the restriction. I should also
mention that you want to careful with CDO code. I was once debugging some CDO
code that sent emails from a loop. I accidentally sent myself about 1500
emails...
--
HTH...
Jim Thomlinson
"Tom Ogilvy" wrote:
Just an observation:
Ron says:
Briefly to explain, this code builds the message and drops it
in the pickup directory, and SMTP service running on the machine
picks it up and send it out to the internet.
I wonder if that will be problematic based on the OP saying:
but my server don´t allow the use of
POP and SMTP.
--
Regards,
Tom Ogilvy
"Jim Thomlinson" wrote:
Check out this link...
http://www.rondebruin.nl/cdo.htm
--
HTH...
Jim Thomlinson
"Luis" wrote:
Hi
I work with the Office 2003 and with Outlook in Exchange , I created a
macro in Excel(VBA) that send email, the only problem is that Outlook
block the send with a message (a program is send mail with the command
Item.Send)
Exists some form of bypass this bar without the human intervention?
I already read about it and in the Outlook 2003 haven't the posibiliti
to deactivate this, and there are authors that say that to bypass this
bar use CDO from the Microsoft , but my server don´t allow the use of
POP and SMTP.
Thank´s
PS. Sorry for mi bad english ;)
Barreiro
|