Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2011

    Unanswered: A Loop function to be wrapped around a function


    I was wondering if someone can help me with some VBA

    I have a sub which updates a pivot table and then sends an e-mail

    I have a second sub which loops round each name

    However, what I need to do is for the Code to send the e-mail and then loop round until there are no more e-mails to send

    I cannot seem to fit the loop statement around the initial statement

    I am attaching the code, I do not think you need to necessarily need to know what the bulk of the code is doing,

    It is just a case of getting the lines of code which states
    " LOOP STARTS HERE" = 1 Line
    "LOOP IS HERE ALSO" = Last several lines

    around my code that I know works.

    Any help would be greatly appreciated

    Last edited by Helen Pippard; 06-18-14 at 01:05.

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 10
    Quote Originally Posted by Helen Pippard View Post
    I am attaching the code
    Hi Helen,

    Can you post your code please?
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts