Can outlook open excel when i get an email using vba

[tonywatsonhelp]

Hi Everyone,
I was woundering if this is possible

I have outlook open most of the time,
I have a macro in excel that works perfectly call "New_Sales"

I noiced that Outlook has a VBA section, so
is it possible to get a macro that I can put in Outlook that
When I get an Email from "Accounts@myemailaddress.com"
it triggers the vba to open the excel document
My Documents/Accounts "New Sales Records" and runs macro
"New_Sales"

thanks

Tony

 

[aaewalsh]

Try This:

Private Sub Application_NewMail()
    Dim objMail As Outlook.MailItem
    Set objMail = Application.ActiveExplorer.Selection.Item(1)
    
    If objMail.SenderEmailAddress = "accounts@myemailaddress.com" Then
        Dim xlApp As Excel.Application
        Set xlApp = CreateObject("Excel.Application")
        xlApp.Visible = True
        xlApp.Workbooks.Open "C:\Users\Username\Documents\Accounts\New Sales Records.xlsx"
        xlApp.Run "New_Sales"
    End If
End Sub

 

[tonywatsonhelp]

Thank you aaewalsh,
I'll give it a go
Thanks
Tony