looping through range of cells & sending multiple emails with outlook

Hello,

What I'm trying to do is loop through a range of cells and send out an email to certain recipients if information has changed. I am starting with row 6 and checking each column in row 6 to see if any changes have been made. All the changes in row 6 are then added to the body of the email message. Once the email is sent, the loop moves to the next row and starts over with a new email. The problem I'm having is that the email will only send for changes made in the first row(row 6). Once the loop moves to row 7, i get an error stating: "Outlook does not recognize one or more names." When I click "debug", the .Send code is highlighted.

Here is the code:

Please Login or Register  to view this content.

Also, I used the www.rondebruin.nl site to get the code for sending emails. Any help would be greatly appreciated. Thanks!

Scott

Hello splosczynski,

The method mrice mentioned will work only if all the addresses listed on your worksheet are in your personal address book. Check that your email addresses are correct and there are no typographical errors.

Sincerely,
Leith Ross