I get a daily email regarding employee terminations (always in the same format). What I would like to do is reference a unique ID# to use a vlookup to check if they have a certain asset in "list1", and if they do, use Outlook to email their manager (also contained in term list) and fill in a few values from "list1". Is this possible? If it can't all be automated, can anyone suggest a good way to make a form to make this as easy as possible?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Generating email from daily excel sheet
- Thread starter Joemaha
- Start date
TIGREBLANCO
Programmer
Yes, you can do it and it can all be automated. Basically you have the right idea (fastest although not most subtle), all it will take is to learn how to use the objects and their properties from each app.
Good Luck!!
Good Luck!!
- Status
