• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 462
  • 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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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