+ Reply to Thread
Results 1 to 8 of 8

Trigger Send&Receive Button

  1. #1
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Trigger Send&Receive Button

    Greetings,
    When I copy and paste following code into Microsoft Outlook 2010 Module1 then the code works.
    Please Login or Register  to view this content.
    I want to run code above from Microsoft Excel 2010 Module1.
    Any idea?
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  2. #2
    Forum Contributor
    Join Date
    09-26-2014
    Location
    Moscow, Russia
    MS-Off Ver
    MSE 10, MSE 13
    Posts
    179

    Re: Trigger Send&Receive Button

    Hi, Herry!

    Let's give early binding a try. Works, if your Excel has the same version as Outlook.

    Please Login or Register  to view this content.
    Best wishes and have a nice day!

  3. #3
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Trigger Send&Receive Button

    Hi Rioran,
    Thank you very much! Solved.

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Trigger Send&Receive Button

    Or even better, remove the reference:
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Trigger Send&Receive Button

    Hi Kyle,
    Why your code is better?
    Last edited by HerryMarkowitz; 07-20-2015 at 06:10 AM.

  6. #6
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Trigger Send&Receive Button

    Because it doesn't need a reference setting, so in theory it's more compatible with different outlook versions

  7. #7
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Trigger Send&Receive Button

    Hi Kyle,
    Your code gives an error on this line;
    Please Login or Register  to view this content.

  8. #8
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Trigger Send&Receive Button

    You can't really get an error on that line. What does it say? Have you already declared it elsewhere?

+ 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. Adjust a code from cell range trigger to button trigger
    By ld2x07 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2014, 10:02 AM
  2. Difference in formats(send/receive)
    By Nucleus in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 09-20-2011, 06:26 AM
  3. SMS send/receive macro and database
    By hattisaeed in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-27-2011, 02:50 PM
  4. How can i send a huge email with different receive?
    By terrywai in forum Outlook Formatting & Functions
    Replies: 3
    Last Post: 07-28-2009, 08:04 PM
  5. Send and receive without display outlook application
    By Calaozao in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2006, 11:16 AM
  6. Send a query and receive data through a Comm Port
    By Jerry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-17-2005, 05:05 PM
  7. Replies: 1
    Last Post: 07-13-2005, 05:05 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