Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

run Outlook from access vba but with different profile and silently

Posted on 2016-09-19
2
Medium Priority
?
67 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
[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
2 Comments
 
LVL 18

Accepted Solution

by:
John Tsioumpris earned 2000 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
By default Outlook 2016 displays only one time zone in the Calendar. The following article explains how to display two time zones in one calendar view.
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…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

721 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