I am looking for assistance building an excel sheet/form to be able to send out Quarterly earnings statements with ease.
I want to be able to input all the data on sheet1, and have sheet 2 be an auto fill sheet/form with a VBA send button that sends an email of the form to them employee.
I have attached a dummy example of what I am wanting to build if someone can help!!
I want to be able to input all the data on sheet1, and have sheet 2 be an auto fill sheet/form with a VBA send button that sends an email of the form to them employee.
I have attached a dummy example of what I am wanting to build if someone can help!!
Name | Pay | Blurb | ||
Bob | $1,158 | Bob@email.com | Thank you for a great quarter! Attached is your earnings report. | |
Stacey | $5,528 | Stacey@email.com | ||
Phil | $9,963 | Phil@email.com | ||
Chris | $2,247 | Chris@email.com |