• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 460
  • Last Modified:

Automating emails from access 2010 to outlook

Two people provided me with some code to automate emails from Access.  Both read as though they will do what I want; however, at this point, I cannot even test them out.  Both seem to be stuck at the same point - objOutlook As Outlook.Application .  I get the error message - Compile error - user-defined type not defined
I am using 2010; perhaps they were using an earlier version?
Some advice would be appreciated
Aileen
Emailmod.JPG
0
msmerry
Asked:
msmerry
  • 4
  • 2
3 Solutions
 
pdebaetsCommented:
0
 
als315Commented:
Do you have Microsoft Outlook 14.0 Object Library selected (in VBA editor Tools-References)?
0
 
msmerryAuthor Commented:
Yes I do have Microsoft Outlook 14.0 Object Library selected.

objApp As Outlook.Application is the sticking point in this piece of code.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
msmerryAuthor Commented:
Click Tools > References and make sure
'* that "Microsoft Office Outlook x.0 Object Library"
'* is checked

This reference does not exist in Access 2010 as far as I can see.
0
 
als315Commented:
You should have Outlook 2010 installed. This library will be installed with Outlook only.
0
 
msmerryAuthor Commented:
OK, that might explain my problems.  I don't use any Microsoft products other than Access; I much prefer Wordperfect and Eudora.  I do have Microsoft Office 2007 on my computer, and did have Access 2007 - until one client decided to upgrade, so I now have Access 2010.  I will have to do all the tricky work on their computer to sort these problems out.  I will try that in the next few days and see if it works.
0
 
msmerryAuthor Commented:
As I am not in a position to test this for the moment - I am about to have a spinal operation - I am closing the question and giving a B because I have yet to prove it to be the solution.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now