Find Jobs
Hire Freelancers

ASP and SMTP Server

$10-30 USD

Completed
Posted over 10 years ago

$10-30 USD

Paid on delivery
I'm really struggling with handling errors in ASP. I have a script that is sending out emails from a MS SQL database where it gets that email addresses and the actual mail itself. The script loops through the addresses, sending 50 at a time so as not to block the queue. The problem is that whenever there is an invalid or illegal email address the sending stops and the page returns a 500 error. So I added the On Error Resume Next tag and now it seems that instead it sends out duplicate emails. I'm not sure how to resolve this but it seems it sends sometimes 2 or sometimes 3 emails to each address. It seems to resend to already sent mails when the page number updates but I'm not entirely sure. But it seems to send the first 50 on page 1 then the first 100 on page 2 then the first 150 on page 3 instead of sending 0-50 on page 1, 51-100 on page 2, 101 - 150 on page 3 etc etc. Either this, or when there's an error in an email address or it is returned undelivered, the script resends all the emails on the current page? Naturally I just want one email to each address and not to stop when there's an email with an email address in the database. I'm not an expert with [login to view URL] and using this so looking for someone who can resolve this for me. When you see the code I'm sure you'll see where the problem is but I just can't figure it out. (Web designer not programmer). Would really appreciate some help as I've been going mental now for the past 6 hours trying to place If [login to view URL] at different places in the code without success. Attached is a copy of the code.
Project ID: 4958282

About the project

7 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, Let's close this today. I already have a similar script on production in my office. Please see pmb.
$54 USD in 3 days
5.0 (3 reviews)
1.9
1.9
7 freelancers are bidding on average $125 USD for this job
User Avatar
ASP Expert here
$79 USD in 1 day
4.7 (52 reviews)
7.0
7.0
User Avatar
i can fix this for you
$30 USD in 3 days
5.0 (41 reviews)
5.4
5.4
User Avatar
Hi, I am ready to start on that. I will suggest you the solution. Thx.
$55 USD in 3 days
5.0 (4 reviews)
3.4
3.4
User Avatar
i can help u in this
$463 USD in 1 day
3.9 (3 reviews)
3.5
3.5
User Avatar
Hi I am working on SQL Server and mySQL from 18 years and can solve your problem
$166 USD in 3 days
4.7 (2 reviews)
2.9
2.9
User Avatar
I have some team-mates who can work together to complete this task. Hope you will consider my offer. Thanks, Neo
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NORWAY
Oslo, Norway
5.0
3
Payment method verified
Member since Jan 24, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.