Connecting Tech Pros Worldwide Help | Site Map

Sendmessage with CDO

Arno R
Guest
 
Posts: n/a
#1: May 7 '07
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
Guest
 
Posts: n/a
#2: May 8 '07

re: Sendmessage with CDO


"Arno R" <arracomn_o_s_p_a_m@planet.nlwrote in message
news:463fabe4$0$16950$ba620dc5@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
Guest
 
Posts: n/a
#3: May 8 '07

re: Sendmessage with CDO



"Rick Brandt" <rickbrandt2@hotmail.comschreef in bericht news:nsO%h.604$mR2.147@newssvr22.news.prodigy.net. ..
Quote:
"Arno R" <arracomn_o_s_p_a_m@planet.nlwrote in message
news:463fabe4$0$16950$ba620dc5@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
Closed Thread


Similar Microsoft Access / VBA bytes