Solved

run Outlook from access vba but with different profile and silently

Posted on 2016-09-19
2
45 Views
Last Modified: 2016-09-19
I'm trying to send emails create a rule and then delete a rule all from within Access 2010 vba.
It all works fine as long as I'm logged into a specific profile in Outlook.

Problem: Users may already have Outlook open to a different profile !

The user does not need to be aware of the profile i need them to be in.
But everytime, i log out of outlook , it keeps prompting me to log into outlook with a specific profile.
here...
Set appOutLook = CreateObject("Outlook.Application")
causes me to choose a profile.

I need to
Set appOutLook = CreateObject("Outlook.Application") but open with correct profile...even if they have Outlook open currently to a different profile ?

Is this possible ?

Thanks
fordraiders
0
Comment
Question by:fordraiders
2 Comments
 
LVL 13

Accepted Solution

by:
John Tsioumpris earned 500 total points
ID: 41805212
If all you want is to send emails then you are better with CDO.sys method...less dependent to external mail clients like Outlook
0
 
LVL 3

Author Closing Comment

by:fordraiders
ID: 41805462
Thnx
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

Suggested Solutions

In this step by step procedure, you will come to know the details of creating an Outlook meeting in 2007, 2010, 2013 & 2016.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
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 …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

772 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