msmerry
asked on
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
I am using 2010; perhaps they were using an earlier version?
Some advice would be appreciated
Aileen
Emailmod.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
'* that "Microsoft Office Outlook x.0 Object Library"
'* is checked
This reference does not exist in Access 2010 as far as I can see.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER
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.
ASKER
objApp As Outlook.Application is the sticking point in this piece of code.