Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
ok,
Thank“s for the answers, but the link mentioned it was my first research place. I still don“t have the answer for my prob, i“m stuck with the security off Outlook Regard“s Barreiro |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
See
http://www.rondebruin.nl/mail/prevent.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Luis" wrote in message ups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
how do you email a portion of a worksheet (range) as an insert into the body of an email? | Excel Programming | |||
send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
Email editor closes when forwarding Excel-embedded email | Setting up and Configuration of Excel |