ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Email question for Ron de Bruin? (https://www.excelbanter.com/excel-programming/363353-email-question-ron-de-bruin.html)

Steph

Email question for Ron de Bruin?
 
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
?




Ron de Bruin

Email question for Ron de Bruin?
 
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
?






Steph

Email question for Ron de Bruin?
 
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
?








Ron de Bruin

Email question for Ron de Bruin?
 
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
?











All times are GMT +1. The time now is 04:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com