473,322 Members | 1,431 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,322 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 5147
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: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.