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

    Unanswered: A Loop function to be wrapped around a function

    Hello

    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

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

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

    Can you post your code please?
    George
    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
  •