Emails using VBA

[dumbitdown]

I'm tracking user deadlines using a spreadsheet to keep an eye on what work is outstanding and make sure they don't miss their deadlines - theres other ways and means of doing this but this is the approaching I'm using now as a quick fix...

Users have multiple entries and deadlines I want the macro to send out 1 email with all the deadlines and the work they are associated with without manually going through and getting all the information, some users have 7/8 deadlines for differeing pieces of work.

I want it to extract the name of the first in the list and put the dealine date and activity name next to it into an email, then go back to the list, find that name again and put the next deadline day and activity name into a new line on the email, then when it's finished with that person, go to the next name and repeat until the list has been exhausted.

If someone can help me with the basics I think I have enough knowledge to build on and add to it as needed...

Thanks

 

[VoG]

You should find some suitable code here Mail from Excel and make/mail PDF files (Windows)