+ Reply to Thread
Results 1 to 3 of 3

email one sheet to many recipients based on email list

  1. #1
    Registered User
    Join Date
    05-01-2008
    Posts
    29

    email one sheet to many recipients based on email list

    I have searched and learned a lot about mailing but am stuck. I read many of Ron De Bruin's information and got as far as I did because of that information. I am getting a compile error "for without next". I don't know where to put the "Next" and I added the "for" coding so I'm sure there is something wrong there also. Column "L" on the active sheet is where the emails are going to populate. Could someone please take a look and fix my code? Thank you in advance. Cindy

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello cdl,

    This should version should work.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

  3. #3
    Registered User
    Join Date
    05-01-2008
    Posts
    29

    Thank you.

    Leith,
    Thank you so much for your help. I almost gave up but you helped immensely. After a little tweeking I got it working.

    I removed the End If from the area shown below:

    Please Login or Register  to view this content.
    I removed the "."s from the Set Rng section:

    Before:
    Please Login or Register  to view this content.
    After:
    Please Login or Register  to view this content.
    and lastly I had to add an End With before the End Sub at the end of the code. Result below:

    Please Login or Register  to view this content.
    Thanks again!
    Cindy

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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