Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ron,
Sorry, but I have another question regarding your CDO code to send emails. At a prior company, I was using your code to send users automated emails. I loved it because I didn't get prompted, and the email could come from a fictitious user (like ). Well, with the new company, the email server is locked to disallow emails coming directly from the smtp server (I think). either way, when I enter the smtp server in the code, I get an error. I talked to the IT dept, and they said they cannot unlock that because of security reasons that other users may find. So, my question is this - I am not so worried about not getting a prompt. Is there any other way to be able to send a user an email using a fictitious "From" like ? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Steph
Can't you use Note from my site : When you also get the Authentication Required Error you can add this three lines. ..Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1 ..Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "username" ..Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "password -- Regards Ron De Bruin http://www.rondebruin.nl "Steph" wrote in message ... Ron, Sorry, but I have another question regarding your CDO code to send emails. At a prior company, I was using your code to send users automated emails. I loved it because I didn't get prompted, and the email could come from a fictitious user (like ). Well, with the new company, the email server is locked to disallow emails coming directly from the smtp server (I think). either way, when I enter the smtp server in the code, I get an error. I talked to the IT dept, and they said they cannot unlock that because of security reasons that other users may find. So, my question is this - I am not so worried about not getting a prompt. Is there any other way to be able to send a user an email using a fictitious "From" like ? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Ron. My apologies. Is that a somewhat recent update to your site? I
guess I should have checked back before I sent the question! That worked perfectly. Thank you. I'm hoping I can make this addition to your addin code? I absolutely love your add-in!! "Ron de Bruin" wrote in message ... Hi Steph Can't you use Note from my site : When you also get the Authentication Required Error you can add this three lines. .Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1 .Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "username" .Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "password -- Regards Ron De Bruin http://www.rondebruin.nl "Steph" wrote in message ... Ron, Sorry, but I have another question regarding your CDO code to send emails. At a prior company, I was using your code to send users automated emails. I loved it because I didn't get prompted, and the email could come from a fictitious user (like ). Well, with the new company, the email server is locked to disallow emails coming directly from the smtp server (I think). either way, when I enter the smtp server in the code, I get an error. I talked to the IT dept, and they said they cannot unlock that because of security reasons that other users may find. So, my question is this - I am not so worried about not getting a prompt. Is there any other way to be able to send a user an email using a fictitious "From" like ? |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Steph
Glad that you got it working I absolutely love your add-in!! Thanks -- Regards Ron De Bruin http://www.rondebruin.nl "Steph" wrote in message ... Hi Ron. My apologies. Is that a somewhat recent update to your site? I guess I should have checked back before I sent the question! That worked perfectly. Thank you. I'm hoping I can make this addition to your addin code? I absolutely love your add-in!! "Ron de Bruin" wrote in message ... Hi Steph Can't you use Note from my site : When you also get the Authentication Required Error you can add this three lines. .Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1 .Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "username" .Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "password -- Regards Ron De Bruin http://www.rondebruin.nl "Steph" wrote in message ... Ron, Sorry, but I have another question regarding your CDO code to send emails. At a prior company, I was using your code to send users automated emails. I loved it because I didn't get prompted, and the email could come from a fictitious user (like ). Well, with the new company, the email server is locked to disallow emails coming directly from the smtp server (I think). either way, when I enter the smtp server in the code, I get an error. I talked to the IT dept, and they said they cannot unlock that because of security reasons that other users may find. So, my question is this - I am not so worried about not getting a prompt. Is there any other way to be able to send a user an email using a fictitious "From" like ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
question for Ron de Bruin on importing | Excel Discussion (Misc queries) | |||
question for Ron de Bruin | Excel Programming | |||
Email Question (Ron De Bruin related) | Excel Programming | |||
Email from Excel att: Ron de Bruin | Excel Programming | |||
A Question for Ron de Bruin | Excel Programming |