XL Bruiser
New Member
- Joined
- Feb 8, 2017
- Messages
- 6
Hello,
I have a workbook that I am creating for Work orders for our business. There are about 6 sheets that have different templates for different repairs. IE sheet one - Heater repairs, sheet two - plumbing repairs, etc.
The goal is to be able to fill out these sheets and then hit the send email macro button and have it generate an email in outlook with those specific sheets attached.
The issue im having is that I don't want to send ALL sheets at once, just the ones that are filled out with the maintenance requests. So we need to be able to specify which sheets are to be attached each time we hit the macro.
Any help is appreciated!
-Excel noob
I have a workbook that I am creating for Work orders for our business. There are about 6 sheets that have different templates for different repairs. IE sheet one - Heater repairs, sheet two - plumbing repairs, etc.
The goal is to be able to fill out these sheets and then hit the send email macro button and have it generate an email in outlook with those specific sheets attached.
The issue im having is that I don't want to send ALL sheets at once, just the ones that are filled out with the maintenance requests. So we need to be able to specify which sheets are to be attached each time we hit the macro.
Any help is appreciated!
-Excel noob