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
> Emaildatabaseobject Command - Override?, Access 2010    
post Dec 3 2018, 10:10 AM

Posts: 420
Joined: 6-October 08
From: indiana, usa

I have an issue with the EmailDatabaseObject command.

1) Problem - multiple databases using this command within a Macro, and it opens Outlook within the Citrix Environment. When opening Outlook within
Citrix, a user ends up with two versions of Outlook.
When everyone was on one MS version of Outlook, this was not an issue. Other than users confused and not happy with two versions of Outlook opened.
The Citrix version and the Desktop version.

Now with 150 users on multiple versions of Outlook. There is a problem. Outlook versions are having trouble emailing information between the environments.

This process is used for over 100 reports.

2) Dream Solution - I would override EmailDatabaseObject with different process. STMP-ing the object or opening the object in Excel.
One idea is on open of the database, EmailDatabaseObject would be renamed to EmailDatabaseObjectMSversion;
and EmailDatabaseObjectRuss would be renamed to EmailDatabaseObject.

The object EmailDatabaseObjectRuss would not use Outlook. Thus, eliminate the big issue of O365 Outlook transferring info to O2010 Outlook. And eliminate the issue of two Outlook versions opened at once.

3) Time-Consuming Solution - This process is used for over 100 reports. The fix would go into each one, and change the code to do the process different.

Thank you in-advance for your insight,


Russ Neuman, Insurance designations = FLMI, ASC, ALMI
Certified MS-Office Specialist
Go to the top of the page
post Dec 3 2018, 11:02 AM

Access Wiki and Forums Moderator
Posts: 75,710
Joined: 19-June 07
From: SunnySandyEggo

Hi Russ,

Not sure if this will help but one possible option is to send email using CDO .

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    17th July 2019 - 03:31 AM