+ Reply to Thread
Results 1 to 2 of 2

Outlook New_Mail Event Macro to Call Excel Macro

  1. #1
    Registered User
    Join Date
    08-25-2014
    Location
    Atlanta, GA
    MS-Off Ver
    2010
    Posts
    6

    Outlook New_Mail Event Macro to Call Excel Macro

    Hi,

    I'm not sure if this is possible, but can I use the Outlook New_Mail event to call an Excel macro?

    I have three emails that are sent to me each morning from Business Objects. Each email has a different subject and an Excel attachment. I already have an Excel macro that updates three pivot tables using the data in each attachment. However, I'm getting tired of opening each email/attachment each morning and kicking off the macro manually. Instead, is it possible to use Outlook's New_Mail event to test each new email's subject and call my current Excel macro if the email's subject is one of the three emails? For example, if one of the three emails' subjects is "xyz", when "xyz" is sent to my inbox, the New_Mail event will recognize it and call my Excel macro.

    What are your thoughts? This would fully automate my process, so I'm really hoping it's possible!

    Thank you!

  2. #2
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    274

    Re: Outlook New_Mail Event Macro to Call Excel Macro

    Outlook doesn't handle the New_Mail event very well, you're better off adding a button to your outlook ribbon that you press manually once the emails arive.

    but to answer your original question of can Outlook call Excel, the answer is yes and if you add a reference to excel in outlook you can do it all within Outlook's VBA editor.

    General outline of the process using Outlook's VBA editor:
    • on the menu bar: Tools>References
    • select: Microsoft Excel 15.0 Object Library (your version number may be different depending on which excel you have)
    • click OK

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to trigger, when date becomes current, a calendar event in outlook?
    By HS_ECSE in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2015, 05:25 PM
  2. Create Outlook Reminder on Excel and transfered to outlook by macro
    By Benjamin2008 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2013, 03:23 PM
  3. [SOLVED] VBA Macro to print to Pdf format and place as attachment in Outlook (Excel & Outlook 2007)
    By Webman1012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2013, 01:25 PM
  4. How Do I call a Macro Using the ComboBox Change Event?
    By Bosco6 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2011, 06:20 PM
  5. Combo Box Change Event with Macro Call
    By Bosco6 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2011, 02:40 PM
  6. Call excel macro to run from Outlook VBA
    By sara.ridley in forum Excel General
    Replies: 1
    Last Post: 11-24-2007, 01:25 PM
  7. [SOLVED] Excel Macro call Word Macro with Parameters
    By Bill Sturdevant in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-25-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1