Hi all,
I have two excel sheets one with 20 sheets with sheet names as school names and another excel file with names of schools with their email address?
I want to email each school their respective sheet only... How do i compare the school name from one sheet to another and send out the emails?
Thanks
how familiar are you with vba?
sheet.name will give you the name of the tab which you can then .find() in the other workbook... maybe something like:
(untested)
Please Login or Register to view this content.
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
Thank you so much for ur response.
Iam fairly new to VBA.
I have tried the code u provided, made some modifications but iam getting an error at the find method. Also the name of the sheet and the school name differs by a word.For example the name of the sheet in other workbook is "Alamo" and the school name in other workbook is IDEAAlamo
IDEAAlamo dave@123.org
So i need a function to compare or contains the sheet name in the school name?? so what function can i use here?
Please Login or Register to view this content.
hmm, i think maybe we have to specify a searchrange within "EmailSheet"
something like this seems like it should work:
i thought you could use find on a worksheet but after testing it seems like maybe not... the .find method defaults to searching for the string / value in part of the found range so your Alamo vs. IDEAAlamo issue shouldn't matter... but if there are two schools with the word Alamo in them we'll need to do something to identify which is which. make sense?Please Login or Register to view this content.
Last edited by simarui; 04-23-2015 at 09:28 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks