Solved

Automating emails from access 2010 to outlook

Posted on 2013-06-14
7
404 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 39

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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

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 39

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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Find out what you should include to make the best professional email signature for your organization.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

813 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now