Solved

Automating emails from access 2010 to outlook

Posted on 2013-06-14
7
424 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

732 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