Outlook 2003 Automation Problem

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I'm trying to run a routine to e-mail a file from Access on an XP computer
with Outlook 2003. It works fine on a Win2K computer with the Office 2000
version of Outlook. I've tried this from both Access XP and Access 2000 on
this XP machine, and it can't seem to recognize that Outlook 2003 is open.
Here's what we have been using:

Set objOutlook = CreateObject("Outlook.Application")

Can anyone give me a clue as to what we need to do to make this work for
Outlook 2003? Thanks.
 
Now I'm thinking it's a problem specific to this computer. I can't even
send a table using the Access built-in function that you access via the File
menu. When I try to do that from Access 2003/XP, I get the following error
message:

"Before attempting to send an e-mail message from Microsoft Office Access,
resolve the problem identified in the previous message, or configure your
computer to send and receive e-mail messages."

However, I never received a previous message and I can't see what would be
wrong with my e-mail configuration. Sending e-mail via Word works fine. If
anyone has any clue about what could be wrong here, I'd really appreciate
the feedback.
 
It turns out that there was something wrong with Outlook. After I did a
"detect and repair," all worked fine. Thanks.
 
Back
Top