Solved

Automating emails from access 2010 to outlook

Posted on 2013-06-14
7
411 Views
Last Modified: 2013-06-28
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
Comment
Question by:msmerry
  • 4
  • 2
7 Comments
 
LVL 12

Accepted Solution

by:
pdebaets earned 167 total points
ID: 39249506
0
 
LVL 40

Assisted Solution

by:als315
als315 earned 333 total points
ID: 39249595
Do you have Microsoft Outlook 14.0 Object Library selected (in VBA editor Tools-References)?
0
 

Author Comment

by:msmerry
ID: 39252273
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
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 

Author Comment

by:msmerry
ID: 39252279
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
 
LVL 40

Assisted Solution

by:als315
als315 earned 333 total points
ID: 39252636
You should have Outlook 2010 installed. This library will be installed with Outlook only.
0
 

Author Comment

by:msmerry
ID: 39255705
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
 

Author Closing Comment

by:msmerry
ID: 39286162
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
Read this checklist to learn more about the 15 things you should never include in an email signature.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question