I am using excel to send mail.
The example workbook below shows that whenever "day left" is less than 10, cell will turn orange.
By keying "x" it send mail with the email subject and msg already keyed in.
However i need to relocate the email address column to another sheet.
Is there anyway for the "Names" to locate/retrieve the correct email addresss from the other sheet?
Example2.xlsm is what i may want it to look like.
Pls look at the two example to get a better idea on what i am asking for.
Hello EugeneE,
Maybe the attached WorkBook is what you want.
Also see the "Please consider" note at the bottom of this post.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Another method.
Please Login or Register to view this content.Please Login or Register to view this content.
AlphaFrog,
Really thanks for your help.
But, I have an error on this code:
Set FoundEmail = Sheets("Email").Range("A:A").Find(What:=Cells(Target.Row, 3), _
LookAt:=xlWhole, _
MatchCase:=False)
The Email list on sheet 2 is somehow act as a database. this is to prevent the user to manually change the email all the time. Jus enter the name, it locate the email and send out automatically.
Last edited by EugeneE; 04-25-2013 at 04:31 AM.
Alright no problem.Originally Posted by Winon
Hello EugeneE,
Maybe the attached WorkBook is what you want.
Also see the "Please consider" note at the bottom of this post.
AlphaFrog,
Sorry, my mistake.
Your code worked.
Thanks for your help.
Pardon me for asking you one more question,
is there a way to combine two different email body for the same name, into one email?
Hello EugeneE,
I have revised the WorkBook, and maybe you would like it more as it is now?
Hi Winon,
That was great. Thanks for your help.
However, if "David" has two task that is about to due, if there a way to merge two msg into an email?
Hello EugeneE,
I see that you have marked this Thread as Solved. So no need for me to reply.However, if "David" has two task that is about to due, if there a way to merge two msg into an email?
Cheers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks