Automate Outlook From PowerPoint

  • Thread starter Thread starter Bill Foley
  • Start date Start date
B

Bill Foley

Hey Gang,

I was wondering if there was any way to suppress the warning window that
pops up when trying to automate Outlook from another Office program. I am
sending a message upon completion of a PowerPoint presentation and it bring
up the "Someone is trying to send a message, blah, blah, blah dialog box.
Do you want to "Allow...", "Yes", "Once", for "x" minutes", etc.!

TIA!

--
Bill Foley, Microsoft MVP (PowerPoint)
Microsoft Office Specialist Master Instructor
www.pttinc.com
Check out PPT FAQs at: http://www.rdpslides.com/pptfaq/
"Success, something you measure when you are through succeeding."
 
Thanks, Sue. Talked with Dmitry and I am on the right path, but I have one
more question:

I am having a problem getting control back to PowerPoint when the message is
sent. If Outlook is not open, my code opens it, sets all the variables,
sends the message, then closes Outlook. This puts the PowerPoint slideshow
back as the active window. GREAT!

However, if Outlook is already open (using GetObject, vice CreateObject),
once I send the message, Outlook remains the active window. I am struggling
with either minimizing the window so the PowerPoint slideshow is active or
closing Outlook. I can't get Outlook to do either. I tried using the
"olWindowState" but that didn't work and I can't figure out how to close
Outlook from PowerPoint if it was already running.

I would be more than glad to post parts of my code if that would help.

TIA!

--
Bill Foley, Microsoft MVP (PowerPoint)
Microsoft Office Specialist Master Instructor
www.pttinc.com
Check out PPT FAQs at: http://www.rdpslides.com/pptfaq/
"Success, something you measure when you are through succeeding."
 
Remember that Outlook has both Inspector and Explorer windows and can have
multiples of each. Did you try traversing the Inspectors and Explorers
collection and changing the WindowState of each non-minimized window?
 
I started looking into it a little before Christmas, but didn't get it
working. I haven't really looked into Outlook enough to know which window
is which. What I normally have open is the Folder List, Preview Pane, and
list of messages. I assume each one of them is considered a separate
window? I will look into the HELP file and see if I can figure it out.

THANKS!

--
Bill Foley, Microsoft MVP (PowerPoint)
Microsoft Office Specialist Master Instructor
www.pttinc.com
Check out PPT FAQs at: http://www.rdpslides.com/pptfaq/
"Success, something you measure when you are through succeeding."
 
None of those are windows. They are each panes of an Explorer window.
(Explorer = folder window. Inspector = item window)

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Bill Foley said:
I started looking into it a little before Christmas, but didn't get it
working. I haven't really looked into Outlook enough to know which window
is which. What I normally have open is the Folder List, Preview Pane, and
list of messages. I assume each one of them is considered a separate
window? I will look into the HELP file and see if I can figure it out.
Click to expand...
 
Back
Top