(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Mass Email using Mass Update
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 [2]  Send Topic Send Topic Print Print
Very Hot Topic (More than 25 Replies) Mass Email using Mass Update (Read 6548 times)
nateboone
Junior Member
**
Offline



Posts: 54
Joined: Dec 19th, 2006
Re: Mass Email using Mass Update
Reply #15 - Jan 2nd, 2007 at 8:20pm
Print Post Print Post  
Ray--

The Error Number is "-3"

--Nate
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Mass Email using Mass Update
Reply #16 - Jan 2nd, 2007 at 8:59pm
Print Post Print Post  
Hello Nate,

Do you have an @pacbell.net email address that you can try using as the From address as a quick test?

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
nateboone
Junior Member
**
Offline



Posts: 54
Joined: Dec 19th, 2006
Re: Mass Email using Mass Update
Reply #17 - Jan 2nd, 2007 at 10:00pm
Print Post Print Post  
yes... I am using Jewel-ya@pacbell.net to test as follows:

emailSuccess = @SendMail("smtp.pacbell.yahoo.com", "WE KIDS",
"TEST <Jewel-ya@pacbell.net>", LE6, "", "", "Hi " + firstName + "--"
+ @NewLine() + @NewLine() + emailInsert + @NewLine() + bottomAddress)

etc.
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Mass Email using Mass Update
Reply #18 - Jan 2nd, 2007 at 10:04pm
Print Post Print Post  
Does that return the same -3 error code?

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
nateboone
Junior Member
**
Offline



Posts: 54
Joined: Dec 19th, 2006
Re: Mass Email using Mass Update
Reply #19 - Jan 2nd, 2007 at 10:13pm
Print Post Print Post  
Yes.

BTW, this code is in the Global Code section of my mass update spec.  Should it be anywhere else?
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Mass Email using Mass Update
Reply #20 - Jan 3rd, 2007 at 1:57am
Print Post Print Post  
nateboone wrote on Jan 2nd, 2007 at 10:00pm:
yes... I am using Jewel-ya@pacbell.net to test as follows:

emailSuccess = @SendMail("smtp.pacbell.yahoo.com", "WE KIDS",
"TEST <Jewel-ya@pacbell.net>", LE6, "", "", "Hi " + firstName + "--"
+ @NewLine() + @NewLine() + emailInsert + @NewLine() + bottomAddress)

etc.


Nate, in the example above you are supplying your email address as "TEST <Jewel-ya@pacbell.net>". Instead, try setting it as just "Jewel-ya@pacbell.net", without the nickname ("TEST") or the enclosing angle braces ("<" and ">"). @SendMail will supply the angle braces, you don't need to.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
nateboone
Junior Member
**
Offline



Posts: 54
Joined: Dec 19th, 2006
Re: Mass Email using Mass Update
Reply #21 - Jan 3rd, 2007 at 2:27am
Print Post Print Post  
Ok... I tried that but unfortunately got the same result, a failure with a -3 failure code.   Sad
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Mass Email using Mass Update
Reply #22 - Jan 3rd, 2007 at 2:30am
Print Post Print Post  
That's strange. I checked the source code and -3 is the error returned when the email server does not like the email address supplied as the sender. It definitely will not like an address with the nickname and the angle braces on it. So leave those off. Can you think of any other reasons that server would not like the supplied sender email address?
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Mass Email using Mass Update
Reply #23 - Jan 3rd, 2007 at 2:38am
Print Post Print Post  
Okay, I just checked that email server using telnet so I could see what was going on. The server is waiting until you send the "MAIL FROM:" message to give you the "authentication required" error that means that that server requires a login and password. When we wrote the @SendMail command, most servers (virtually all) spoke the "HELO" version of the POP protocol that requires that you don't send the login and password. But, as everyone is aware, spammers took advantage of that and abused third party mail servers. So, these days we see mail servers that speak the EHLO version of the POP protocol that requires a login and password, or the server requires that you come from a IP address that is part of its family.

For Sesame 2.0, we added the login and password as optional arguments, so @SendMail can happily talk with either kind of email server.

I would recommend that you find and use a command line email program.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Re: Mass Email using Mass Update
Reply #24 - Jan 3rd, 2007 at 4:01am
Print Post Print Post  
Nate -

Go to my website:  [url]www.s-o-s.bz[/url], click on FEEDBACK and send me the completed form.  I will be happy to send you a copy of my database which demonstrates the use of @sendmail for mass mailings.

Also, feel free to call me to discuss it, if you like:  (813) 889-9725.
  
- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
WWW WWW  
IP Logged
 
nateboone
Junior Member
**
Offline



Posts: 54
Joined: Dec 19th, 2006
Re: Mass Email using Mass Update
Reply #25 - Jan 4th, 2007 at 7:14pm
Print Post Print Post  
So is Sesame 2.0 out yet?  Where I might be directed for more info about this?
  
Back to top
 
IP Logged
 
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Re: Mass Email using Mass Update
Reply #26 - Jan 4th, 2007 at 7:19pm
Print Post Print Post  
Nate -

You don't need Sesame 2.0 to use @sendmail (just in case that's why you're asking ... and we would [b]ALL[/b] like to see (and have) version 2.0.

Did you receive my database?  Does it help?  Any questions?  Again, you are welcome to call me at (813) 889-9725 if you need assistance implementing it.

I recently sent out over 400 personalized e-mails by typing it once and with a few mouse clicks.  I would be ABSOLUTELY LOST without @sendmail, at this point.
  
- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1 [2] 
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge