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

DP wrote:[color=blue]
> 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
>
>[/color]
Have you checked out SendObject? Ex:
DoCmd.SendObject acSendNoObject, , acFormatTXT, strTo, strCC, strBCC,
strSubject, strEmailBody, True

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" <oil@vinegar.com> wrote in message
news:OjHKf.1300$F56.1247@newsread3.news.atl.earthl ink.net...[color=blue]
> DP wrote:[color=green]
> > hi,
> >
> > i've got a piece of code, which sends an e mail to a customer, asking[/color][/color]
them[color=blue][color=green]
> > 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[/color][/color]
not[color=blue][color=green]
> > crash?? cos i tried it on my m8s pc, and the program just haults!! and[/color][/color]
he[color=blue][color=green]
> > didint believe me that it works, but it works fine on my home (this) pc.
> >
> > thanx
> >
> > dev
> >
> >[/color]
> Have you checked out SendObject? Ex:
> DoCmd.SendObject acSendNoObject, , acFormatTXT, strTo, strCC, strBCC,
> strSubject, strEmailBody, True[/color]

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.

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" <lylefairfield@aim.com> wrote in message
news:1140603686.879631.109620@z14g2000cwz.googlegr oups.com...[color=blue]
> 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.
>[/color]

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:lGWKf.42971$K42.33430@newsfe7-win.ntli.net...[color=blue]
> 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[/color]
overdue."[color=blue]
> & vbNewLine & "Please can you return this film to your nearest Blockbuster
> store, or a penalty charge will apply after 2 days." & vbNewLine &[/color]
vbNewLine[color=blue]
> & "Thank You. " & vbNewLine & "Yours Faithfully," & vbNewLine & vbNewLine[/color]
&[color=blue]
> "Blockbuster Team", True
>
>
> End Sub
>
> the above works, but only if i have outlook express installed. i'll try[/color]
the[color=blue]
> bit u gave me later, and get bak to u.
>
> tanx
>
> dev
>
> "salad" <oil@vinegar.com> wrote in message
> news:OjHKf.1300$F56.1247@newsread3.news.atl.earthl ink.net...[color=green]
> > DP wrote:[color=darkred]
> > > hi,
> > >
> > > i've got a piece of code, which sends an e mail to a customer, asking[/color][/color]
> them[color=green][color=darkred]
> > > 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[/color][/color][/color]
does[color=blue]
> not[color=green][color=darkred]
> > > crash?? cos i tried it on my m8s pc, and the program just haults!! and[/color][/color]
> he[color=green][color=darkred]
> > > didint believe me that it works, but it works fine on my home (this)[/color][/color][/color]
pc.[color=blue][color=green][color=darkred]
> > >
> > > thanx
> > >
> > > dev
> > >
> > >[/color]
> > Have you checked out SendObject? Ex:
> > DoCmd.SendObject acSendNoObject, , acFormatTXT, strTo, strCC, strBCC,
> > strSubject, strEmailBody, True[/color]
>
>[/color]

DP wrote:
[color=blue]
> "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[/color]

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

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" <TIMMY!@PurplePandaChasers.Moertherium> wrote in message
news:dthukv$aoe$1@coranto.ucs.mun.ca...[color=blue]
> DP wrote:
>[color=green]
> > "Blockbuster Team - You have an Overdue Film Rental", _
> > " Our system has notified us, that you currently have a film[/color][/color]
overdue."[color=blue][color=green]
> > & vbNewLine & "Please can you return this film to your nearest[/color][/color]
Blockbuster[color=blue][color=green]
> > store, or a penalty charge will apply after 2 days." & vbNewLine &[/color][/color]
vbNewLine[color=blue][color=green]
> > & "Thank You. " & vbNewLine & "Yours Faithfully," & vbNewLine &[/color][/color]
vbNewLine &[color=blue][color=green]
> > "Blockbuster Team", True[/color]
>
> 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[/color]

DP wrote:
[color=blue]
> 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!![/color]

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