Send email to user based on a drop down list

Hi everyone,

I am trying to send various rows of data in an Excel spreadsheet to different users based on a drop down list. Example: I want to send rows 2 and 5 to one email in the drop down list, and then other rows to a different email address. There will be hundreds more lines, but only maybe 12 different emails.

This is to send my umpires a schedule for the week or 2. I have attached a text spreadsheet. The emails all belong to me.

paste into a module
run: SendEmails2All

you must add Microsoft Outlook object in VBE: tools, references

Please Login or Register  to view this content.