By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,777 Members | 1,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,777 IT Pros & Developers. It's quick & easy.

Sendmessage with CDO

P: n/a
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
May 7 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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
May 7 '07 #2

P: n/a

"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
May 8 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.