Access data collection

[Donald C. Huebner]

I have had a problem.. with a new copy of Windows 7 and a new copy of Office
2007 being installed on my computer, I sill cannot get the collect data
through email button/feature to work after reading many help articles. I get
an error saying Outlook is not installed correctly because Access could not
get Outlook to start. When I start Outlook it runs great. Could anyone help
me resolve this problem? I'm not sure where to go to find more information
about this.

Thank you,
Donald C. Huebner

 

[Arvin Meyer [MVP]]

You might try getting Access to start Outlook if it isn't already running:

Dim objOutlook As Object
Set objOutlook = GetObject("Outlook.Application")

 

[Donald C. Huebner]

I'm not for sure 100% but I thought it should have not been running if I
turned Outlook off in the task's panle. Even with that checked and off I get
the same error. And, if I need to place that code, where to since this is a
feature of Access 2007 this time?

 

[Arvin Meyer [MVP]]

The code I provided should go at the beginning of whatever code you are
using to retrieve the Outlook data.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Gary Voth]

For what it's worth, I'm having the exact same issue on all of the Windows 7
/ Office 2007 machines I have tried, 32-bit and 64-bit.

Other email-related features seem to work (e.g., SendObject).

 

[Gary Voth]

Arvin, this is not really a suitable solution, since the Collect Data via
Email command is unavailble to run programmatically in most cases. For
example, the command is dimmed when a form is active--the underelying table
must be open.

In any case, when I wrote some button click event code to open a table first
and then get an instance of the Outlook application (it must be running), the
command has no effect (it does nothing):

Private Sub cmdCollectData_Click()
DoCmd.OpenTable "tblMembers"
Dim objOutlook As Object
Set objOutlook = GetObject(, "Outlook.Application")
DoCmd.RunCommand acCmdCollectDataViaEmail ' Nothing happens here!
End Sub

 

[Gary Voth]

Don, I figured it out. The culprit is the Microsoft Office Outlook Connector
for Windows Live Hotmail.

The Access data collection add-in apparently fails when the Outlook
Connector is installed and/or the Live mail is the only account type.

On my systems, the Live email accounts are set up as the primary / only
email accounts in Outlook. I have not tried this scenario to see if it woks
against a regular Exchange or POP3 account when the Live mail account is set
up as a secondary account.

Arvin, is there a way to report this interoperability issue to the Microsoft
Access and Oulook Connector teams?

 

[Gary Voth]

I figured it out--the presence of the Outlook Connector for Windows Live is
the culprit, at least when this is the only/primary email account installed
in Outlook (haven't tried it configured another way).