Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 46
Default 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
?



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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
?





  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 46
Default 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
?







  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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
?









Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
question for Ron de Bruin on importing JohnE Excel Discussion (Misc queries) 2 August 23rd 07 01:52 AM
question for Ron de Bruin JT[_2_] Excel Programming 3 September 17th 04 02:37 AM
Email Question (Ron De Bruin related) Lobo[_2_] Excel Programming 5 March 1st 04 02:01 PM
Email from Excel att: Ron de Bruin Edgar[_3_] Excel Programming 1 January 26th 04 04:03 PM
A Question for Ron de Bruin Jamal[_2_] Excel Programming 3 January 9th 04 04:12 PM


All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"