Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 10th, 2003, 12:23 PM
Registered User
 
Join Date: Aug 2003
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Outlook is not able to recieve messages(Excel Macr

Set objOutlook = CreateObject("Outlook.Application")
    Set objMapiName = objOutlook.GetNamespace("MAPI")
    Set objFolder = objMapiName.GetDefaultFolder(olFolderInbox)
cnt = objFolder.Items.Count
If cnt = 0 Then Label1.Visible = True...etc..etc



This program doesn't cause Outlook to
actually check for new messages.If there are messages in the inbox it tries to read the one alraedy downloaded.Please help me to find a code for actually receive new messages






Similar Threads
Thread Thread Starter Forum Replies Last Post
vba work outlook with excel sheet qunatphil Excel VBA 1 April 16th, 2008 12:30 PM
VBA in excel and outlook dlindamood2000 Excel VBA 19 December 7th, 2006 10:16 AM
Linking excel file to display messages from serve Kaustav Excel VBA 0 June 2nd, 2006 07:14 AM
VBA Excel, outlook createobject Willie Johnson Jr Excel VBA 0 March 10th, 2006 05:11 AM
Export Messages from Outlook Express using VB6 ANVAR VB How-To 0 April 13th, 2005 06:14 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.