Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Turn application visibility off (http://www.outlookbanter.com/outlook-vba/97367-turn-application-visibility-off.html)

Eric November 24th 09 09:22 PM

Turn application visibility off
 
I'm writing some VBA code in Excel that needs to send data to Word and then
send out the Word documents as attachments to emails. In Word VBA I can say
something like

Application.Visible=False

and this will create the documents in the background without the user seeing
everything happening. When it comes to send the emails, the email pops up on
the screen before it sends out. I can't find a Visible-equivalent method for
the Outlook application. Is there a way to set Outlook or the mailitem object
to not display itself?

Dmitry Streblechenko November 24th 09 09:50 PM

Turn application visibility off
 
No MailItem object is shown unles you explicitly call MailItem.Display.
What exactly do you see and how do you create and send messages?

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"Eric" wrote in message
...
I'm writing some VBA code in Excel that needs to send data to Word and
then
send out the Word documents as attachments to emails. In Word VBA I can
say
something like

Application.Visible=False

and this will create the documents in the background without the user
seeing
everything happening. When it comes to send the emails, the email pops up
on
the screen before it sends out. I can't find a Visible-equivalent method
for
the Outlook application. Is there a way to set Outlook or the mailitem
object
to not display itself?




Ken Slovak - [MVP - Outlook] November 25th 09 02:28 PM

Turn application visibility off
 
It's probably a Simple MAPI Inspector. Not much you can do with that other
than use the OOM instead of a Simple MAPI call.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Dmitry Streblechenko" wrote in message
...
No MailItem object is shown unles you explicitly call MailItem.Display.
What exactly do you see and how do you create and send messages?

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"Eric" wrote in message
...
I'm writing some VBA code in Excel that needs to send data to Word and
then
send out the Word documents as attachments to emails. In Word VBA I can
say
something like

Application.Visible=False

and this will create the documents in the background without the user
seeing
everything happening. When it comes to send the emails, the email pops up
on
the screen before it sends out. I can't find a Visible-equivalent method
for
the Outlook application. Is there a way to set Outlook or the mailitem
object
to not display itself?






All times are GMT +1. The time now is 04:11 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com