+ Reply to Thread
Results 1 to 4 of 4

Outlook email upon specific text in cell

  1. #1
    Forum Contributor
    Join Date
    08-29-2011
    Location
    Wisbech England
    MS-Off Ver
    Excel 2010
    Posts
    308

    Outlook email upon specific text in cell

    Hi
    Can somone please take a look at my code and see why it doesn't work properly???
    It should pull the information's from the the row as below when text in column 25 change to "OPEN"
    Currently I am getting this error "Compile Error: For without Next"
    Thank you for your help :-)
    Dan

    Please Login or Register  to view this content.

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Outlook email upon specific text in cell

    your have no Next I statement after the End IF...

    you should line up your With End With and IF and END IF
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Forum Contributor
    Join Date
    01-14-2014
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    240

    Re: Outlook email upon specific text in cell

    You have a for with no next. Whack a
    Next I
    Above the end sub. That will close the loop.

  4. #4
    Forum Contributor
    Join Date
    08-29-2011
    Location
    Wisbech England
    MS-Off Ver
    Excel 2010
    Posts
    308

    Re: Outlook email upon specific text in cell

    thank you all for your help it worked !

+ 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. Launch outlook and Email specific range of cells
    By Jvollmer33 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 09-19-2013, 07:09 PM
  2. Outlook: How to set a specific group of members/email address
    By Ericng in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 07-10-2013, 05:07 AM
  3. Add to Excel from Outlook when a email body contain a specific text
    By mathewfer in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2013, 08:28 AM
  4. Add to Excel from Outlook when a email body contain a specific test
    By mathewfer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2013, 02:52 AM
  5. [SOLVED] insert a hyperlink into an excel cell to refer to a specific email in outlook
    By Joe McLoughlin in forum Excel General
    Replies: 3
    Last Post: 08-03-2012, 05:25 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