Sendmessage with CDO

[Arno R]

Hi all,

I am having problems (again!) sending messages with SendObject.
I need to sent different mails with different attachments to only a few (about 6) people
On one computer it works, on another not (same app, same code).
The 'sick' computer seems to stop sending after the first mail.
Code is running without any warning or errors, but sending another mail only works after shutting down Access.
Using A2k here.

I am considering CDO but the main 'hesitation' is that users can not see that the mail has been sent indeed.
Also there is no possibility of having a copy of the mail like with OE (or am I missing things here?)
My users would like to see the mail (sort of a check that the attachment was the right one)
Also CDO needs a permanent connection to the Internet, Or ??

Any comments please.

Arno R

[Rick Brandt]

"Arno R" <ar****************@planet.nlwrote in message
news:46***********************@text.nova.planet.nl ...
Hi all,

I am having problems (again!) sending messages with SendObject.
I need to sent different mails with different attachments to only a few (about
6) people
On one computer it works, on another not (same app, same code).
The 'sick' computer seems to stop sending after the first mail.
Code is running without any warning or errors, but sending another mail only
works after shutting down Access.
Using A2k here.

I am considering CDO but the main 'hesitation' is that users can not see that
the mail has been sent indeed.
Also there is no possibility of having a copy of the mail like with OE (or am I
missing things here?)
My users would like to see the mail (sort of a check that the attachment was the
right one)
Also CDO needs a permanent connection to the Internet, Or ??

Any comments please.
I usually provide a prompt where the user can opt to have the message BCC'd to
himself. About as good a solution as any. It provides proof that the message
was actually sent and it gives them a copy for their records.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Arno R]

"Rick Brandt" <ri*********@hotmail.comschreef in bericht news:ns***************@newssvr22.news.prodigy.net. ..

"Arno R" <ar****************@planet.nlwrote in message
news:46***********************@text.nova.planet.nl ...
Hi all,

I am having problems (again!) sending messages with SendObject.
I need to sent different mails with different attachments to only a few (about
6) people
On one computer it works, on another not (same app, same code).
The 'sick' computer seems to stop sending after the first mail.
Code is running without any warning or errors, but sending another mail only
works after shutting down Access.
Using A2k here.

I am considering CDO but the main 'hesitation' is that users can not see that
the mail has been sent indeed.
Also there is no possibility of having a copy of the mail like with OE (or am I
missing things here?)
My users would like to see the mail (sort of a check that the attachment was the
right one)
Also CDO needs a permanent connection to the Internet, Or ??

Any comments please.
I usually provide a prompt where the user can opt to have the message BCC'd to
himself. About as good a solution as any. It provides proof that the message
was actually sent and it gives them a copy for their records.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Simple and good solution! Thanks!

Arno R