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

SendObject

P: n/a
DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][,
bcc][, subject][, messagetext][, editmessage][, templatefile]

Using windows2000 and OutLook Express v6

I have Access 2000 and Access 97 installed on the same machine.
To achieve this and so that Access applications open with the appropriate
version of access I have two new file types
extension .Ac7 for access 97 apps and .md2k for access 2000 apps.

The sendobject method works for Access 2000 apps but NOT for Access97 apps

DoCmd.SendObject in Access2000
Opens the Outlook Express with a mesage defined by the arguments used in the
command.

Access97 complains :-
Microsoft Access cannot open a mail session
Check your mail application to ensura that it is working properly

Have tried:-
reinstall Access97
reinstall OutLook Express
try using .mdb as the Acess97 file type/extension
No go!

Any suggestion please.
--
Jim Bunton
jB*****@Blueyonder.co.uk
13 Westbourne Road
Trowbridge
Wilts. BA14 0AJ
Tel: 01225 765 541
Mobile: 07919 283 968


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.538 / Virus Database: 333 - Release Date: 10/11/2003
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Jim,

I am familiar with this problem also.
I think there is no solution, think it's just one of these bugs that one never understands ...

Problem occurs when there are more Access versions installed on the same Pc.
If only A97 installed everything works as expected.
If only A2k installed everything works as expected.

If you only need to open Outlook then you can assign a hyperlinkAddress to a 'cmdMail'
I use following code in a form (on Current):
If Not IsNull(Me!Email) Then 'This is the e-mailaddress
Me!cmdMail.Enabled = True
Me!cmdMail.HyperlinkAddress = "MailTo:" & Me!Email
Else
Me!KnpMail.Enabled = False
End if

--
Hope this helps
Arno R

"J Bunton" <jB*****@BlueYonder.co.uk> schreef in bericht
news:hU**************@news-binary.blueyonder.co.uk...
DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][,
bcc][, subject][, messagetext][, editmessage][, templatefile]

Using windows2000 and OutLook Express v6

I have Access 2000 and Access 97 installed on the same machine.
To achieve this and so that Access applications open with the appropriate
version of access I have two new file types
extension .Ac7 for access 97 apps and .md2k for access 2000 apps.

The sendobject method works for Access 2000 apps but NOT for Access97 apps

DoCmd.SendObject in Access2000
Opens the Outlook Express with a mesage defined by the arguments used in the
command.

Access97 complains :-
Microsoft Access cannot open a mail session
Check your mail application to ensura that it is working properly

Have tried:-
reinstall Access97
reinstall OutLook Express
try using .mdb as the Acess97 file type/extension
No go!

Any suggestion please.
--
Jim Bunton
jB*****@Blueyonder.co.uk
13 Westbourne Road
Trowbridge
Wilts. BA14 0AJ
Tel: 01225 765 541
Mobile: 07919 283 968


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.538 / Virus Database: 333 - Release Date: 10/11/2003

Nov 12 '05 #2

P: n/a
Thank you for your response Arno. Your lucidity and succinctness are much
appreciated.

I guess that using the hyperlink could be better than nothing but it doesn't
seem to offer the functionality of 'SendObject'.

But thanks anyway
"Arno R" <ar****************@tiscali.nl> wrote in message
news:3f**********************@dreader2.news.tiscal i.nl...
Jim,

I am familiar with this problem also.
I think there is no solution, think it's just one of these bugs that one never understands ...
Problem occurs when there are more Access versions installed on the same Pc. If only A97 installed everything works as expected.
If only A2k installed everything works as expected.

If you only need to open Outlook then you can assign a hyperlinkAddress to a 'cmdMail' I use following code in a form (on Current):
If Not IsNull(Me!Email) Then 'This is the e-mailaddress
Me!cmdMail.Enabled = True
Me!cmdMail.HyperlinkAddress = "MailTo:" & Me!Email
Else
Me!KnpMail.Enabled = False
End if

--
Hope this helps
Arno R

"J Bunton" <jB*****@BlueYonder.co.uk> schreef in bericht
news:hU**************@news-binary.blueyonder.co.uk...
DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]

Using windows2000 and OutLook Express v6

I have Access 2000 and Access 97 installed on the same machine.
To achieve this and so that Access applications open with the appropriate version of access I have two new file types
extension .Ac7 for access 97 apps and .md2k for access 2000 apps.

The sendobject method works for Access 2000 apps but NOT for Access97 apps
DoCmd.SendObject in Access2000
Opens the Outlook Express with a mesage defined by the arguments used in the command.

Access97 complains :-
Microsoft Access cannot open a mail session
Check your mail application to ensura that it is working properly

Have tried:-
reinstall Access97
reinstall OutLook Express
try using .mdb as the Acess97 file type/extension
No go!

Any suggestion please.
--
Jim Bunton
jB*****@Blueyonder.co.uk
13 Westbourne Road
Trowbridge
Wilts. BA14 0AJ
Tel: 01225 765 541
Mobile: 07919 283 968


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.538 / Virus Database: 333 - Release Date: 10/11/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.538 / Virus Database: 333 - Release Date: 10/11/2003
Nov 12 '05 #3

P: n/a
Jim,
You are welcome
I guess that using the hyperlink could be better than nothing but it doesn't
seem to offer the functionality of 'SendObject'.


In fact SendObject is VERY limited. If you also need to send attachments you're lost.
If you need more on this do a google search on 'mail attachments' and the like.

I just shortly found class-code for OE (thanks Lyle F)
Look at thread starting with MessageID <3f********************@dreader2.news.tiscali.nl >

--
Hope this helps
Arno R

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.