Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

run Outlook from access vba but with different profile and silently

Posted on 2016-09-19
2
Medium Priority
?
73 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 19

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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

885 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