Turn application visibility off

  • Thread starter Thread starter Eric
  • Start date Start date
Status
Not open for further replies.
E

Eric

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?
 
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)

-

"Eric" <Eric> wrote in message

news:6D80A4B2-EE18-4927-ABAF-BCA4A17D566B@microsoft.com...
> 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?
 
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.

"Dmitry Streblechenko" <dmitry@dimastr.com> wrote in message

news:OSc%23qCVbKHA.2160@TK2MSFTNGP02.phx.gbl...
> 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)
>

>

>

> -
> "Eric" <Eric> wrote in message
> news:6D80A4B2-EE18-4927-ABAF-BCA4A17D566B@microsoft.com...
> > 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?


>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
P turn off the default "all day" check box in new calendar items. How? Using Outlook 1
M New Calendar Appointments: Conditionally turn off reminder and show time as free Using Outlook 14
S E-mails marked as read turn back to unread after a couple of seconds Using Outlook 1
Q Prompt button to auto turn on Out of Office Outlook VBA and Custom Forms 3
M Where is the setting to *turn off* open calendar in a new window? Using Outlook 3
L How do you turn off Outlook contacts "hints" popup Using Outlook 2
N How to turn off autocorrect in contact notepads Using Outlook 2
A remove or turn off outlook.com contact folder from outlook 2016 Using Outlook 4
A Stop Rule (not turn off) that Delays Outgoing Items Outlook VBA and Custom Forms 1
A Emails automatically forwarding but no rule to turn off Using Outlook 2
R How to turn OFF the Reminders for shared calendar events but not off personal Using Outlook 1
K Appointments turn into meeting requests Using Outlook 0
O How to turn off the prompt to permanently delete messages upon exiting? Using Outlook 2
W Outlook Desktop alert, notification, popup - turn off programattic Outlook VBA and Custom Forms 1
C SQLDUMPER library does not turn on correctly when the computer isturned on each time. BCM (Business Contact Manager) 1
R How do I turn off the Business Contact Manager startup in Outlook BCM (Business Contact Manager) 1
H How turn off outlook security warning dialog box from outlook Outlook VBA and Custom Forms 1
V turn off shared calender reminders/leaving personal calender remin Using Outlook 7
G Error - "Customized functionality in this application will not work because the certificate" Outlook VBA and Custom Forms 1
S HTML Code Embedded in String Within Open Outlook Email Preventing Replace(Application.ActiveInspector.CurrentItem.HTMLBody From Working Outlook VBA and Custom Forms 4
bmtjedi Set objApp = Application Not Working in O365-32bit Using Outlook 1
avant-guvnor Outlook.Application now produces error Outlook VBA and Custom Forms 5
C Custom Application Form send Email to Another User Using Outlook 1
N Select Existing BCM Business Contact in C# application Using Outlook 0
S Using "start application" rule action Using Outlook 2
smokiibear windows security mail application not accepting username and password Using Outlook 0
Y VBA - Application Filedialog Hidden Behind Outlook Using Outlook 0
T Synchronize outlook appointments through web application. Using Outlook 1
O Outlook 2010 Stops Working When Accounting Application Tries To Send eMail Using Outlook 4
C MAPI to access a 64 bit Outlook from a 32 bit application; or access via ODBC Using Outlook 0
K Handling application.quit event Outlook VBA and Custom Forms 8
M VSTO C#: How do I declare an application scope variable? Outlook VBA and Custom Forms 2
T Run application from cmd button Outlook VBA and Custom Forms 5
D Outlook 2007 Will Not Send Mail From C# Application Outlook VBA and Custom Forms 7
P Supporting threads in Outlook VBA application Outlook VBA and Custom Forms 1
R vba instantiated internetExplorer.application differs from user la Outlook VBA and Custom Forms 1
K How to disconnect Application.COMAddIns.Item().Object? Outlook VBA and Custom Forms 4
D outlook.exe application error - breakpoint has been reached. fix? BCM (Business Contact Manager) 1
P Drag and Drop mails from Outlook to Clarion6 Application Outlook VBA and Custom Forms 5
J Office application does not match advisory. Why? BCM (Business Contact Manager) 3
D Application.ActiveInspector() is Null on Ribbon Load Outlook VBA and Custom Forms 1
D Application.ActiveInspector().CurrentItem Returns Wrong(Old) Value Outlook VBA and Custom Forms 3
L RE: BCM Office Application Issue BCM (Business Contact Manager) 1
R Can calendar be displayed in another Office application? Outlook VBA and Custom Forms 1
wallisellener contacts visibility BCM (Business Contact Manager) 3

Similar threads

Back
Top