+ Reply to Thread
Results 1 to 7 of 7

[VBA] Start Macro, when E-Mail arrives in shared Mailbox?

  1. #1
    Registered User
    Join Date
    09-13-2022
    Location
    Germany
    MS-Off Ver
    365 Business
    Posts
    4

    Question [VBA] Start Macro, when E-Mail arrives in shared Mailbox?

    Hello dear forum.

    I am new here and hope you can help me.

    Unfortunately I only know a little Excel-VBA (and minimal PPT-VBA), that is: I can solve my problems and tasks partly by myself and sometimes I need an idea (from a forum), which brings me on the right way and I can almost solve my problem by myself.
    Sometimes I just need someone to show me the code so I can learn something new again. So now I teach myself outlook vba - I peek at the others and learn from it.

    Now this is my first outlook project and I have a question where I can't find the solution though and hope someone can show me how to do it.

    My script:
    I made myself a script that is always started when an email arrives. If it is an order with a certain word in the email body, then copy the mail and add the due date in the subject line.

    The script (see below) works quite perfectly.

    My problem:
    However, it should now work with the shared mailbox in the same way, or rather, I actually need the script exclusively for the shared mailbox.

    Can you help me?

    Many thanks already...

    Patrick

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by xXsodaxX; 09-15-2022 at 07:11 AM.

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: [VBA] Start Macro, when E-Mail arrives in shared Mailbox?

    So just to get this right in my head, the above code does what you want it to do but its currently working against your own Outlook mailbox?

    And you need it to point to a shared mailbox instead?
    If someone has helped you then please add to their Reputation

  3. #3
    Registered User
    Join Date
    09-13-2022
    Location
    Germany
    MS-Off Ver
    365 Business
    Posts
    4

    Re: [VBA] Start Macro, when E-Mail arrives in shared Mailbox?

    Exactly.

    I wrote the script to practice outlook vba. And it works for my personal mailbox.

    And now I want to customize the script for my shared mailbox.
    No matter what I try, it does not work. I can't get it to work.

    Can you show me how to do it?

    Thanks a lot for your help.

    Patrick

  4. #4
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: [VBA] Start Macro, when E-Mail arrives in shared Mailbox?

    I've only really played around with this once or twice but I think you need to set up your Initialize differently

    Please Login or Register  to view this content.

    Not tested it out I'm afraid but found this code in an old one that I wrote a few years ago (and no doubt nicked from google!) but now I don't have access to a shared box to try it.

  5. #5
    Registered User
    Join Date
    09-13-2022
    Location
    Germany
    MS-Off Ver
    365 Business
    Posts
    4

    Re: [VBA] Start Macro, when E-Mail arrives in shared Mailbox?

    Great.
    Thanks a lot for your help.

    will try it later and tell you if it worked

  6. #6
    Registered User
    Join Date
    09-13-2022
    Location
    Germany
    MS-Off Ver
    365 Business
    Posts
    4

    Re: [VBA] Start Macro, when E-Mail arrives in shared Mailbox?

    Please Login or Register  to view this content.
    Thank you very much, dear pjwhitfield. Your tip was absolute top!

    very kind regards

    Patrick

  7. #7
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: [VBA] Start Macro, when E-Mail arrives in shared Mailbox?

    Glad to help, please mark the thread as SOLVED to close it cheers

+ 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. Mail Alert if an expected mail (at a specific time daily) doesn't arrives in the inbox
    By dineshsachidananda in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 11-10-2017, 09:00 AM
  2. Save mails sent from shared mailbox in that shared mailbox's Sent folder
    By LordClick in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-22-2016, 03:30 PM
  3. Outlook 2010 VBA Code to open a link from an unread mail in a Shared Mailbox
    By MHamid in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 10-31-2015, 03:46 PM
  4. [SOLVED] Macro run for every new mail arrives - Outlook 2013
    By Narasimharao Nandula in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-26-2014, 08:01 AM
  5. Excel Macro using VB Script to send emails from Common/Shared Mailbox
    By k.vijayendran in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2014, 01:48 PM
  6. [SOLVED] Show newl message envelop notification for all mailbox/shared mailbox added in outlook
    By Goku in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 07-04-2014, 01:23 PM
  7. How to run a excel macro when a e mail arrives to outlook with a constantsubject
    By venkatatcts in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2009, 03:24 AM

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