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

WinXP-A97: Can't start mailsession

P: n/a
Hi all,

In the past I have had this issue with sendobject not working with A97.
Often it was related to more Access versions installed.
IME SendObject would only work with the latest version.

But I never had the issue one of my clients is having now:
-- Clean install of Windows XP home SP2.
-- Clean install of Access97.
-- Trying to sendmail: Message "Can't start mailsession ..."

Btw: Using Outlook Express here.
No CDonts available ... only OE
In fact this is a brand nwe PC with *only* Windows XPHome SP2 installed and Access97.
The only software that is needed on this PC is this Access-app.
The ability to send mail is very essential for this app...

I fear I need to install A2k (this also means licences...) to get the mail from Access started on these PC's.

Any ideas?
Thanks.

Arno R
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Arno R wrote:
Btw: Using Outlook Express here.
No CDonts available ... only OE
In fact this is a brand nwe PC with *only* Windows XPHome SP2 installed and Access97.


I think Windows XP includes CDOSYS (C:\WINDOWS\System32\cdosys.dll).

Public Sub VerySimpleSendMailWithCDOSample()
' requires reference to cdosys.dll
' (Microsoft CDO for Windows 2000 library)

Dim iCfg As CDO.Configuration
Dim iMsg As CDO.Message

Set iCfg = New CDO.Configuration
Set iMsg = New CDO.Message

With iCfg.Fields
..Item(cdoSendUsingMethod) = cdoSendUsingPort
..Item(cdoSMTPServerPort) = 25
..Item(cdoSMTPServer) = "smtp.mail.yahoo.ca"
..Item(cdoSMTPAuthenticate) = cdoBasic
..Item(cdoSendUserName) = "lylefair"
..Item(cdoSendPassword) = "Password"
..Item(cdoSendEmailAddress) = "Lyle Fairfield <ly******@yahoo.ca>"
..Update
End With

With iMsg
..Configuration = iCfg
..Subject = "Test"
..To = "ly***********@aim.com"
..TextBody = "Test"
..Send
End With
End Sub

I haven't used SendObject for a long time. I find CDO faster, stronger,
better, cooler.

--
Lyle Fairfield
Nov 13 '05 #2

P: n/a

"Lyle Fairfield" <ly***********@aim.com> schreef in bericht news:2s******************@read2.cgocable.net...
Arno R wrote:
Btw: Using Outlook Express here.
No CDonts available ... only OE
In fact this is a brand nwe PC with *only* Windows XPHome SP2 installed and Access97.


I think Windows XP includes CDOSYS (C:\WINDOWS\System32\cdosys.dll).

Public Sub VerySimpleSendMailWithCDOSample()
' requires reference to cdosys.dll
' (Microsoft CDO for Windows 2000 library)

Dim iCfg As CDO.Configuration
Dim iMsg As CDO.Message

Set iCfg = New CDO.Configuration
Set iMsg = New CDO.Message

With iCfg.Fields
.Item(cdoSendUsingMethod) = cdoSendUsingPort
.Item(cdoSMTPServerPort) = 25
.Item(cdoSMTPServer) = "smtp.mail.yahoo.ca"
.Item(cdoSMTPAuthenticate) = cdoBasic
.Item(cdoSendUserName) = "lylefair"
.Item(cdoSendPassword) = "Password"
.Item(cdoSendEmailAddress) = "Lyle Fairfield <ly******@yahoo.ca>"
.Update
End With

With iMsg
.Configuration = iCfg
.Subject = "Test"
.To = "ly***********@aim.com"
.TextBody = "Test"
.Send
End With
End Sub

I haven't used SendObject for a long time. I find CDO faster, stronger,
better, cooler.

--
Lyle Fairfield


Thanks Lyle!
I will try this cdosys.dll. I guess one can send attachments also?
If it works it will be a solution for some new PC's the client has purchased.

The 'old' shops (client has a couple of shoe-shops) will continue using Win '98 ... for quite a while
So I will need to change the code that sends the daily mail to adapt for the situation (OS).
Arggghhh.... But thanks.

Why is M$ making this so hard ? Who do they not fix some issues??
This docmd.sendmail is a disaster for a long while already isn't it ??

Arno R

Nov 13 '05 #3

P: n/a
One can do everything with CDO as far as sending goes, and at midnight
it turns into a pizza and a six pack of Sleeman's Cream Ale.

You could, of course, use Outlook Express in the new and in the old,
but it might give you a few headaches (yes, OE is fully programmable).

Nov 13 '05 #4

P: n/a
One can do everything with CDO as far as sending goes, and at midnight
it turns into a pizza and a six pack of Sleeman's Cream Ale.

You could, of course, use Outlook Express in the new and in the old,
but it might give you a few headaches (yes, OE is fully programmable).

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.