SendObject challenge

B

Bob Hughes

I have several programs using Access 2K that loop through a record set in
order to generate Emails. They all work perfectly on my home computer
running XP home. They also worked on my former win 2K PC, But they fail
on my new laptop running XP Pro

The first program just loops through a record set, collects email
addresses & then sends a 680 character message to all the email adrs at
once. It then goes on to send out several more individual emails.
This program sends the first email but does not send any more. It does
loop through all the code and executes the SendObject for each new email.
Commenting out the first email allows all the next 4 to be sent
correctly. (They do not use a record set loop)

The second program loops through a record set, creates a 1616 word text
message and sends individual message to each recipient. It only sends the
first message, but does continue to loop thru code & execute rest of
SendObject instructions.

In both cases if I shorten the message the system appears to work. I have
tried 2 different mail package [Eudora (my normal pkg) and outlook] &
they both fail the same way.

When I say fails to send message I mean the SendObject code is executed,
but the mail does not turn up in the mail out box. No error messages are
generated. After the first failure, no Email can be sent with SendObject.
The program has to be reloaded to continue testing.

I am running slightly different Norton virus checkers, both supplied by
my ISP.

Any clues would be greatly appreciated. This is becoming very
frustrating. Fortunately I can still use my home computer to send these.
I volunteer for a small organization < http://oakridgestrail.org/> & send
out regular Emails.

Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top