Open/Close Outlook - Via Excel VBA

Status
Not open for further replies.

Choppork

Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
I am looking for the correct syntex to open and then close Outlook via Excel VBA code.

The code would reside in an Excel application.

Thank you in advance.

Choppork

1325 CDT

June 19, 2013
 

larry

Senior Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
This would open outlook:
Dim outlookApp As Outlook.Application
' create Outlook session
Set outlookApp = GetOutlookApp

I'm not sure about closing.

For some Excel sample code, see http://www.jpsoftwaretech.com/excel-vba/send-email-from-excel/. It's all for sending email, but the same basic steps are used to create appointments or contacts.
 

Choppork

Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
This would open outlook:

Dim outlookApp As Outlook.Application

' create Outlook session

Set outlookApp = GetOutlookApp

I'm not sure about closing.

For some Excel sample code, see http://www.jpsoftwaretech.com/excel-vba/send-email-from-excel/. It's all for sending email, but the same basic steps are used to create appointments or contacts.
Larry - Thank you for the response!!

While you are correct with the above VBA code, when embedded within an application, that code will open Outlook as a background application only, (i.e. - not visable), and the Outlook application will close when the calling application VBA code is stopped.

Also - the normal (expected) syntex to make the (opened) Outlook application visable, (i.e. (outlookApp.visable=True), do not work.

I (should) have made my request more clear, the code I would like would open MS Outlook, make it visable, and allow the application to remain open when the calling code is halted. I have the code to close an open Outlook appplication.

Any/all assistance is greatly appreceiated!!

Thank you in advance.

Choppork

1330 CDT

June 20, 2013
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
J Outlook doesn't close. Cannot open outlook without going to task manager Using Outlook 1
J Recent emails disappear when I change folders in Outlook. They reappear when I close and re-open Out Using Outlook 6
P Would like to find a shortcut to close all open Outlook messages at the same time Using Outlook 4
W When I close Outlook 2010 and then re-open it, Outlook cannot connect with the Exchange server. Using Outlook 1
Y (Shared Folder) Using the preview pane to open and close a fax, without opening the email itself Using Outlook 1
P All of a sudden I cannot open the INBOX file. It asks me to close any application and restart. Done that several times. Nothing Using Outlook 1
F A dialog box is open, close it and try again. Don't see any dialog box open. Using Outlook 5
D Macro to Close Open Messages Outlook VBA and Custom Forms 3
L Cannot open PST file for first session each day Using Outlook 6
A How to open a specific link automatically with outlook 2016 Outlook VBA and Custom Forms 5
H Upon opening Outlook, make my popmail inbox open instead of outlook.com inbox Using Outlook 1
sahameed82 SharePoint calendar directly open in Outlook Using Outlook 0
N .pst archive from work will not open/import on Microsoft 365 Exchange Server Administration 0
C Outlook 2016/2019 hangs after being open for an extended period Using Outlook 4
M Where is the setting to *turn off* open calendar in a new window? Using Outlook 3
W Automatically open attachments without automatically printing them Using Outlook 0
Y Open and Save Hyperlink Files in multiple emails Outlook VBA and Custom Forms 9
J How to open OST file in Outlook 2019 & 2016 Using Outlook 1
C Can't Open Outlook 365 Using Outlook 0
D after delete mail, open the next one Outlook VBA and Custom Forms 0
N VBA Script to Open highlighted e-mail and Edit Message Outlook VBA and Custom Forms 5
M outlook won't open! Using Outlook 1
N Open & Save VBAProject.Otm using VBA Code Outlook VBA and Custom Forms 1
E Unable to open Outlook 2010 after adding new email account Using Outlook 4
M other user's mailbox won't open, forms disappeared Using Outlook 42
S SendFromAccount - Problem trying to test existing value in open email Outlook VBA and Custom Forms 2
J Open an outlook email by Subject on MS Access linked table with VBA Outlook VBA and Custom Forms 10
D Add Tetxbox at form open Outlook VBA and Custom Forms 1
U Catching ModuleSwitch events after "open in new window" Outlook VBA and Custom Forms 2
Andrew Quirl Open attachment, manipulate without add-on program? Outlook VBA and Custom Forms 5
S Reminder Dialog Open Button Using Outlook 2
A How to open a specific link automatically with outlook Outlook VBA and Custom Forms 13
S Outlook 2010 Cannot Open Attachments Using Outlook 14
N open the hyperlink in Outlook directly instead of browser Using Outlook 1
S Outlook does not open the .pst file created by the Outlook Using Outlook 5
A open Outlook with multiple windows. Using Outlook 0
K open calendar from address book Outlook VBA and Custom Forms 1
T Double clik behavior on agenda open a new meeting request Using Outlook 1
E Open olNoteItem Attachment Outlook VBA and Custom Forms 6
G Can't open .pst. Message could not access default folder (Outlook 2010 (.pst). Before that was backi Using Outlook 0
I Outlook 2010, 2013 will not open .msg or .eml files Using Outlook.com accounts in Outlook 1
Diane Poremsky Outlook VBA: Work with Open Item or Selected Item New Slipstick.com Articles 0
O Windows 10 x64 Outlook 2013 - URL does not open (anymore) Using Outlook 3
Hudas VBA find and open an email without looping thru each email in the inbox Outlook VBA and Custom Forms 1
Diane Poremsky Rules & Alerts Dialog Won't Open New Slipstick.com Articles 1
Diane Poremsky Outlook 2013: Control Panel Mail Won't Open New Slipstick.com Articles 0
O Cannot open or save calendar items Using Outlook 0
Diane Poremsky Outlook Links Won't Open In Windows 10 New Slipstick.com Articles 1
C scanpst.exe will not open Using Outlook 0
K cant read email or open attachement Using Outlook 0
Similar threads


















































Top