Previous Thread
Next Thread
Print Thread
Rate Thread
#241030 03/18/2003 4:23 AM
Joined: Oct 2002
Posts: 165
Member
Member
Offline
Joined: Oct 2002
Posts: 165
Anyone have any insight on the mail all users function. I tried it for the 1st time in forever and after some time... I got an error (I was kinda tired... so I lost the page and the exact detail).

I found in my sendmail some traces of the mailing, received a copy myself and received some bounces, but sendmail appears that there may have been 1,000 mails?? and when I polled my mods and friends... no one saw the mail. I have about 18,000 members.

After scanning mysql... it appears that there are some bad emails early on. Probably the AOL users, who don't put the @aol.com suffix to there name. If anyone could figure a way to replace all email in the wrong format to a default email... that might work. I think the bad emails break the script??

Any suggestions? Any way to break the size of the database up into smaller parts for the mailing?

Sponsored Links
Joined: Apr 2001
Posts: 3,266
Member
Member
Offline
Joined: Apr 2001
Posts: 3,266
How bout putting your email in the BCC field and trying the mass email again. Any members with bad email address's will come back after it mails out. Some server's require the BCC field filled in. Right now it send out 40 at a time so the email in BCC will get any multiple of 40 to the end of member emails. That way if you have 18000 members you should get 450 of that email.

sf49rminer #241032 03/18/2003 11:36 AM
Joined: Oct 2002
Posts: 165
Member
Member
Offline
Joined: Oct 2002
Posts: 165
Thank, Omega. I do believe I left the address blank at the bottom... I'll try that.

I still think it would be cool to replace those emails with no @ extension with a either a dummy email or append them with "@aol.com" since there is a large probability that would correct them.

sf49rminer #241033 03/19/2003 11:57 AM
Joined: Oct 2002
Posts: 165
Member
Member
Offline
Joined: Oct 2002
Posts: 165
hmmm.. tried another mail with our email in as sender and went for it. I received 25 mails, which based on Omega's info that sent approximately 25x40 or 1,000 pieces. At that point the Amin screen displayed an Action Cancelled as per the attached. Any ideas?

Attachments
73625-badmail2.jpg (0 Bytes, 20 downloads)

alsalmicom #241034 03/19/2003 11:32 PM
Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
Heya...

Sadly I've never been able to get the mass email function to work. I've been round and round with Rick. But otherwise... it's frustrating. It seems to re-start and loop itslef.... some people get 6 emails, others none.

Here is a thread where Dave_L gave some direction to how to add loggin to the email function. This let me see what steps it was doing etc....

You also might try... adding

set_time_limit(0);

to the top of the dosendemail script. Your screen shot seems to make me think that maybe it timed out. <shrug>

I wish I knew the answer. I just got done trying to get an email to everyone at my site... and gave up.


Sponsored Links
Daine #241035 03/20/2003 11:19 AM
Joined: Sep 2001
Posts: 64
Junior Member
Junior Member
Offline
Joined: Sep 2001
Posts: 64
You could do it the hard way by exporting the email address from the Users table into a comma delimited file then copy/pasting that into outlook or whatever email agent you use. But if you have thousands of email addresses - that might not work either.

navdan #241036 03/24/2003 2:43 PM
Joined: Sep 2001
Posts: 64
Junior Member
Junior Member
Offline
Joined: Sep 2001
Posts: 64
I actually resorted to a bulk email program to resolve the "email everyone" problem. I do a query in MySQL:

Code
SELECT U_Email FROM  `w3t_Users`  WHERE U_Approved =  'no'  


I exported the results to a .csv file and imported it into WorldCast by Fairlogic Systems. I kinda like WorldCast because it verifies email addresses before it sends the bulk email. All totaled, it took about 4 min to verify and send 85 emails.

I havent tried it on my entire user base (over 1400) so I don't know if it'll work as quickly. but I'll let you know when that happens.

navdan #241037 03/25/2003 2:27 AM
Joined: Jan 2002
Posts: 674
Junior Member
Junior Member
Offline
Joined: Jan 2002
Posts: 674
Dang I was hoping to use this feature for the old poster accounts to see if they were still alive.


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,575
Posts293,930
Members13,823
Most Online6,139
Sep 21st, 2024
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2025 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.1
(Snapshot build 20240918)