+ Reply to Thread
Results 1 to 5 of 5

VBA formula not working

  1. #1
    Registered User
    Join Date
    09-16-2019
    Location
    Howick
    MS-Off Ver
    2007
    Posts
    11

    VBA formula not working

    Hello.

    I have an excel document with a VBA formula that is set up.
    The document is supposed to send reminder emails according to a due date to my gmail account which is synced with my outlook account.

    The VBA is programmed with the outlook account but for some reason it is not sending the reminder emails.

    Is there someone that can assist me with this issue please.

    I can attach a sample of the document.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,445

    Re: VBA formula not working

    By all means do post your code ( don't forget the tags )
    Is this question related to Excel or solely to Outlook?
    Cheers

  3. #3
    Registered User
    Join Date
    09-16-2019
    Location
    Howick
    MS-Off Ver
    2007
    Posts
    11

    Re: VBA formula not working

    The question is related to excel as there is possibly something wrong with the VBA formula.

    Please see the file attached.

    I am not receiving any reminder emails - please check if the VBA formula is correct and if there are any possible mistakes.
    Attached Files Attached Files

  4. #4
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: VBA formula not working

    You have last row variables set on columns BZ and CH and yet your data in sample does not extend to there. Is this correct for real data set??

  5. #5
    Registered User
    Join Date
    09-16-2019
    Location
    Howick
    MS-Off Ver
    2007
    Posts
    11

    Re: VBA formula not working

    Thank you for your reply

    Yes that is correct for the real data set

+ 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. Format a part of a text working with only value not working with formula result
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2017, 05:41 AM
  2. [SOLVED] help index and match macro not working but formula working??
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2016, 06:37 AM
  3. Replies: 3
    Last Post: 05-14-2015, 07:32 AM
  4. Correct/Working (Index,Match) formula not working between cells
    By barnerd in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 02-11-2014, 01:20 PM
  5. Replies: 9
    Last Post: 03-08-2013, 11:50 AM
  6. Replies: 2
    Last Post: 08-17-2012, 08:16 AM
  7. Replies: 2
    Last Post: 08-01-2012, 11:53 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