473,382 Members | 1,204 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

SendObject

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
3 5152
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Bret Shortall | last post by:
Using the SENDOBJECT action command in a Macro works fine if you hard code in their email address. SENDOBJECT TO bret@emailaddress.com SUBJECT This is the Subject line...
1
by: Alfred | last post by:
Hi I am using access 2002 1.0 I want to email a word or html file using the docmd.sendobject The document must be send as a attachment. 2.0 Second I would like to tell the Docmd.Sendobject to...
4
by: Fred | last post by:
I want to insert DHL and FedEx tracking links with the waybill numbers in the body of emails I am sending using sendobject. I am not sending attachments. DHL and FedEx use long links that...
2
by: Lumpierbritches | last post by:
Hello, and thank you in advance for any and all assistance. I'm having a problem. This code worked years ago, what am I doing wrong? Private Sub SendeMail_Click() DoCmd.SendObject...
8
by: Andy Kasotia | last post by:
Warning message in Outlook 2003 while using SendObject. When i try to use sendobject to send an email, a warning massage pops up, saying that "Outlook is trying to send an email.......if this is...
2
by: Marcus | last post by:
Is there a way to have Access 2002 open a particular email client, when using DoCmd.SendObject? So far, Access simply opens the default email client that is set under Control Panel/Internet...
3
by: Fred Zuckerman | last post by:
Hello All, I had written a quick email procedure for a client that uses DoCmd.SendObject. However they have the SR-1 version of Access 2K. They do not have the SP-3 upgrade. The procedure does...
2
by: Andy_Khosravi | last post by:
I posted this question about two days ago, but for some reason it never actually got put up. I couldn't' find it with searches, so I am re-posting it now. I apologize if this is a double post. ...
0
by: (PeteCresswell) | last post by:
Another thread got me going on SendObject. Works like a champ for emailing somebody a .SNP of a report as in: DoCmd.SendObject acSendReport, "rptMaturities", "Snapshot Format", "pCresswell", ,...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.