Solved

run Outlook from access vba but with different profile and silently

Posted on 2016-09-19
2
52 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 16

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

679 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