UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Sendobject Using Old Email Program, Access 2016    
 
   
BruceM
post Dec 6 2018, 03:54 PM
Post#1


UtterAccess VIP
Posts: 7,754
Joined: 24-May 10
From: Downeast Maine


For years I have been using SendObject to send emails from Access. Until recently we had IBM Notes (aka Lotus Notes), but have finally made the transition to Outlook. I have set Outlook as my default Email. When clicking an email link in a web page or Word document, or when using Application.FollowHyperlink, an Outlook messsage opens. However, with SendObject it is stuck on IBM Notes. Any ideas why?

I can convert to FollowHyperlink, or use some other method if preferable, but I'm curious as to what is going on. It could have an effect elsewhere.

Most likely I won't reply until tomorrow. Thanks in advance.
Go to the top of the page
 
pere_de_chipstic...
post Dec 6 2018, 05:47 PM
Post#2


UtterAccess Editor
Posts: 10,339
Joined: 8-November 07
From: South coast, England


Hi Bruce

I'm not sure if this will help, but I've had recently started having problems with SendObject with Outlook, Older Windows 10 builds seem to work while the same Access DB fails on other PCs with later Windows 10 builds.

I am now writing an Outlook Automation function to replace the SendObject command.

--------------------
Warm regards
Bernie
Go to the top of the page
 
projecttoday
post Dec 6 2018, 07:14 PM
Post#3


UtterAccess VIP
Posts: 10,352
Joined: 10-February 04
From: South Charleston, WV


I'm sure you've (both) seen this. So I'll ask why you're writing a new function, Bernie.

--------------------
Robert Crouser
Go to the top of the page
 
pere_de_chipstic...
post Dec 7 2018, 05:39 AM
Post#4


UtterAccess Editor
Posts: 10,339
Joined: 8-November 07
From: South coast, England


Hi Robert

I already have a function, not dissimilar to Daniel's, for Outlook Automation, which I was intending to use but it needs modifying; hence my post, which was only intended to confirm that there does appear to be a bug in some of the later builds of Windows/Access(?) and I was intending to replace SendObject with Outlook Automation!

--------------------
Warm regards
Bernie
Go to the top of the page
 
DanielPineault
post Dec 7 2018, 05:59 AM
Post#5


UtterAccess VIP
Posts: 6,273
Joined: 30-June 11



There have been issues off and on with SendObject, and even more so now with O365/win10. I don't use it anymore at all and always use Outlook automation! That said, just to add to the never ending onslaught of o365/win10 bugs there is a new one involving MAPI, so if you use MAPI check out http://www.devhut.net/2018/12/03/access-bug-mapi/.

--------------------
Daniel Pineault (2010-2018 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
BruceM
post Dec 7 2018, 08:06 AM
Post#6


UtterAccess VIP
Posts: 7,754
Joined: 24-May 10
From: Downeast Maine


Thanks to all. It's good to know it wasn't something I was doing. I suspected a problem, but couldn't figure out how to phrase the search.

How about Application.FollowHyperlink? I will switch to Outlook automation if necessary, or if it turns out to be the best choice, but for now we are living between worlds, where some users have been switched to Outlook and others have not.
Go to the top of the page
 
DanielPineault
post Dec 7 2018, 08:13 AM
Post#7


UtterAccess VIP
Posts: 6,273
Joined: 30-June 11



If you can't be guaranteed that users have Outlook, why not use CDO?

--------------------
Daniel Pineault (2010-2018 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
projecttoday
post Dec 7 2018, 08:29 AM
Post#8


UtterAccess VIP
Posts: 10,352
Joined: 10-February 04
From: South Charleston, WV


I think the users have Outlook. The problem is that it's not going to Outlook for every user.

--------------------
Robert Crouser
Go to the top of the page
 
BruceM
post Dec 7 2018, 08:38 AM
Post#9


UtterAccess VIP
Posts: 7,754
Joined: 24-May 10
From: Downeast Maine


It is both. Some users don't have Outlook yet, and others (me, for instance) are not getting the expected result from SendObject.

I don't know the exact schedule for rolling out Outlook to all users, but no more than a month or two, I expect. I hope to find the simplest solution that will work for now, with a plan to use Outlook automation as soon as everybody has Outlook.
Go to the top of the page
 
projecttoday
post Dec 7 2018, 08:43 AM
Post#10


UtterAccess VIP
Posts: 10,352
Joined: 10-February 04
From: South Charleston, WV


I see. I must have been thinking of another post here.

--------------------
Robert Crouser
Go to the top of the page
 
DanielPineault
post Dec 7 2018, 08:18 PM
Post#11


UtterAccess VIP
Posts: 6,273
Joined: 30-June 11



You could check the registry and then use the appropriate function.

--------------------
Daniel Pineault (2010-2018 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    12th December 2018 - 12:04 PM