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

sending email crashes with ms acecss

P: n/a
DP
hi,

i've got a piece of code, which sends an e mail to a customer, asking them
to return a rened film.

however, it only works if u have ms outlook express installed.

is there any way of doing a check or somthing, so that the program does not
crash?? cos i tried it on my m8s pc, and the program just haults!! and he
didint believe me that it works, but it works fine on my home (this) pc.

thanx

dev
Feb 20 '06 #1
Share this Question
Share on Google+
8 Replies


P: n/a
DP wrote:
hi,

i've got a piece of code, which sends an e mail to a customer, asking them
to return a rened film.

however, it only works if u have ms outlook express installed.

is there any way of doing a check or somthing, so that the program does not
crash?? cos i tried it on my m8s pc, and the program just haults!! and he
didint believe me that it works, but it works fine on my home (this) pc.

thanx

dev

Have you checked out SendObject? Ex:
DoCmd.SendObject acSendNoObject, , acFormatTXT, strTo, strCC, strBCC,
strSubject, strEmailBody, True
Feb 21 '06 #2

P: n/a
DP
sorry, this is wat i've got;

Private Sub cmdFilmMail_Click()
DoCmd.SendObject _
, _
, _
, _
"Enter E-Mail address HERE", _
, _
, _
"Blockbuster Team - You have an Overdue Film Rental", _
" Our system has notified us, that you currently have a film overdue."
& vbNewLine & "Please can you return this film to your nearest Blockbuster
store, or a penalty charge will apply after 2 days." & vbNewLine & vbNewLine
& "Thank You. " & vbNewLine & "Yours Faithfully," & vbNewLine & vbNewLine &
"Blockbuster Team", True
End Sub

the above works, but only if i have outlook express installed. i'll try the
bit u gave me later, and get bak to u.

tanx

dev

"salad" <oi*@vinegar.com> wrote in message
news:Oj*****************@newsread3.news.atl.earthl ink.net...
DP wrote:
hi,

i've got a piece of code, which sends an e mail to a customer, asking them to return a rened film.

however, it only works if u have ms outlook express installed.

is there any way of doing a check or somthing, so that the program does not crash?? cos i tried it on my m8s pc, and the program just haults!! and he didint believe me that it works, but it works fine on my home (this) pc.

thanx

dev

Have you checked out SendObject? Ex:
DoCmd.SendObject acSendNoObject, , acFormatTXT, strTo, strCC, strBCC,
strSubject, strEmailBody, True

Feb 22 '06 #3

P: n/a
Could you, please, confirm that you mean "Outlook Express", the e-mail
program that is installed with Internet Explorer, and thus, present, I
believe on almost all Windows OS computers, rather than "Outlook" the
Personal Management and E-mail program which is part of Microsoft
Office?
Is it possible that you mean that the OutputTo crashes unless there is
a default E-mail Account set up in Outlook Express?
TTBOMK Access's SendObject is dependent on a MAPI compatible E-mail
program, together with an E-mail SMTP account, being set as the default
E-Mail program through Internet Options.
I abandoned OutputTo for the most part several years ago because it is
has more than one vulnerability, including not operating at all when
there is no child window in the main Access window; that may be
corrected by now.
If you are using Windows 2000 or later version you can use CDO with a
bit of code. It seems to be quite easy for some, but not for others.

Feb 22 '06 #4

P: n/a
DP
i'm using outlook express 6, which comes with windows xp.

but my m8 does not have it, and so it has an error, and starts a msn
passport thing.

dev

"Lyle Fairfield" <ly***********@aim.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
Could you, please, confirm that you mean "Outlook Express", the e-mail
program that is installed with Internet Explorer, and thus, present, I
believe on almost all Windows OS computers, rather than "Outlook" the
Personal Management and E-mail program which is part of Microsoft
Office?
Is it possible that you mean that the OutputTo crashes unless there is
a default E-mail Account set up in Outlook Express?
TTBOMK Access's SendObject is dependent on a MAPI compatible E-mail
program, together with an E-mail SMTP account, being set as the default
E-Mail program through Internet Options.
I abandoned OutputTo for the most part several years ago because it is
has more than one vulnerability, including not operating at all when
there is no child window in the main Access window; that may be
corrected by now.
If you are using Windows 2000 or later version you can use CDO with a
bit of code. It seems to be quite easy for some, but not for others.

Feb 22 '06 #5

P: n/a
DP
hi,

i've done;

Private Sub cmdFilmMail_Click()

DoCmd.SendObject acSendNoObject, , acFormatTXT,
"Enter e-mail address here", _
, _
, _
"Blockbuster Team - You have an Overdue Film Rental", _
" Our system has notified us, that you currently have a film overdue."
& vbNewLine & "Please can you return this film to your nearest Blockbuster
store, or a penalty charge will apply after 2 days." & vbNewLine & vbNewLine
& "Thank You. " & vbNewLine & "Yours Faithfully," & vbNewLine & vbNewLine &
"Blockbuster Team", True

but its all in RED!!. can u sort that little bit out, the order is messed up
and i cant figure it out?

dev

"DP" <DP@hotmail.com> wrote in message
news:lG*******************@newsfe7-win.ntli.net...
sorry, this is wat i've got;

Private Sub cmdFilmMail_Click()
DoCmd.SendObject _
, _
, _
, _
"Enter E-Mail address HERE", _
, _
, _
"Blockbuster Team - You have an Overdue Film Rental", _
" Our system has notified us, that you currently have a film overdue." & vbNewLine & "Please can you return this film to your nearest Blockbuster
store, or a penalty charge will apply after 2 days." & vbNewLine & vbNewLine & "Thank You. " & vbNewLine & "Yours Faithfully," & vbNewLine & vbNewLine & "Blockbuster Team", True
End Sub

the above works, but only if i have outlook express installed. i'll try the bit u gave me later, and get bak to u.

tanx

dev

"salad" <oi*@vinegar.com> wrote in message
news:Oj*****************@newsread3.news.atl.earthl ink.net...
DP wrote:
hi,

i've got a piece of code, which sends an e mail to a customer, asking them to return a rened film.

however, it only works if u have ms outlook express installed.

is there any way of doing a check or somthing, so that the program does
not
crash?? cos i tried it on my m8s pc, and the program just haults!! and he didint believe me that it works, but it works fine on my home (this)

pc.
thanx

dev

Have you checked out SendObject? Ex:
DoCmd.SendObject acSendNoObject, , acFormatTXT, strTo, strCC, strBCC,
strSubject, strEmailBody, True


Feb 22 '06 #6

P: n/a
DP wrote:
"Blockbuster Team - You have an Overdue Film Rental", _
" Our system has notified us, that you currently have a film overdue."
& vbNewLine & "Please can you return this film to your nearest Blockbuster
store, or a penalty charge will apply after 2 days." & vbNewLine & vbNewLine
& "Thank You. " & vbNewLine & "Yours Faithfully," & vbNewLine & vbNewLine &
"Blockbuster Team", True


You may want to check your english in your message above, it's
absolutely atrocious. Presumably, this is representing a company.

Not meant to be a personal knock, DP, but it's horrible english.
There's absolutely nothing worse than receiving something that looks
like it was written by someone not fluent in the language the message is
composed in (I say, ending my sentence with a preposition...).

Also, if your message is in red, then you're probably sending it in
html. Not sure why, though, you've specified acFormatTXT.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Feb 22 '06 #7

P: n/a
DP
no offence m8, but u didint help me one bit. the message i've got is only a
sample, so i can see wat it looks like. obviously i'm going to change it!!

the code i gave before, does not work, the writing appears in red and i dont
know wat the problem is.

dev
"Tim Marshall" <TI****@PurplePandaChasers.Moertherium> wrote in message
news:dt**********@coranto.ucs.mun.ca...
DP wrote:
"Blockbuster Team - You have an Overdue Film Rental", _
" Our system has notified us, that you currently have a film overdue." & vbNewLine & "Please can you return this film to your nearest Blockbuster store, or a penalty charge will apply after 2 days." & vbNewLine & vbNewLine & "Thank You. " & vbNewLine & "Yours Faithfully," & vbNewLine & vbNewLine & "Blockbuster Team", True


You may want to check your english in your message above, it's
absolutely atrocious. Presumably, this is representing a company.

Not meant to be a personal knock, DP, but it's horrible english.
There's absolutely nothing worse than receiving something that looks
like it was written by someone not fluent in the language the message is
composed in (I say, ending my sentence with a preposition...).

Also, if your message is in red, then you're probably sending it in
html. Not sure why, though, you've specified acFormatTXT.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

Feb 22 '06 #8

P: n/a
DP wrote:
no offence m8, but u didint help me one bit. the message i've got is only a
sample, so i can see wat it looks like. obviously i'm going to change it!!


Just making sure you knew. 8) I'm glad you did, but you'd be surprised
how many post secondary students these days try to pass something like
that off on a formal essay.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Feb 22 '06 #9

This discussion thread is closed

Replies have been disabled for this discussion.