Hi macenmin,

Welcome to ExcelFox

What you've asked for is doable. However, it is more of a project requirement that a query for a solution and/or to solve a specific problem. There is fair amount of information on this site regarding sending emails via outlook using VBA. A little search will give you results. If you give a shot at putting a few code together, I'm sure you'll find enough info. Developers on this forum, or any similar forum will be more interested in helping if it is more of a solution required than an entire project. Having said that, there is a hire help section in this forum if you are willing to make some payment for this project.