I have two excel sheets - the first has a list of companies I need to email, the second is a table of company contacts (company name, email, phone). I need to pull the emails for only the companies I've filtered in my first spreadsheet, and copy them into an outlook email. Is there a way to auto pull the emails for only the companies I need from the contact db?

Currently I just view the 2 sheets side by side and filter the companies I need form the contact db, then copy those address into an email. This process isn't too bad, but when theres 100's of contacts I need to email it becomes a big time waster.

Thanks in advance!

Dave