Hi,
I'm using to code below to find an email address in cell G36 then send email. The problem is that it is sending an email to everyone in G36 for all the other sheets aswell. I only want it to send an email for the active sheet, the one I'm looking at. Help... thanks.
Please Login or Register to view this content.
Last edited by pike; 06-12-2010 at 08:33 PM. Reason: added code tags to newbie post
Your code is checking all sheets in the book because that what it is set up to do. You need to remove refrences to the workbook and replace with activesheet.
Try something like this:
Please Login or Register to view this content.
No good. Error with the .SendMail?
try thisPlease Login or Register to view this content.
Last edited by scottwhittaker2333; 06-14-2010 at 02:10 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks