hooper12345
New Member
- Joined
- May 12, 2015
- Messages
- 36
Hello helpful readers,
I have a very lengthy and complicated VBA code that is currently running through the data entered on one sheet, compiling it on another and then formatting those results onto a mock paper print out that my company uses. What I need is to email those paper forms while still having the option to print. The layout isn't perfect and requires some adjusting and it does change yearly.
I guess what I'm asking is, How do I insert a code (I don't have one) to run automatically after the VBA code runs to compile the reports? I would like them to be attachments that don't need to be saved in an outside folder since all the needed information is readily available in the workbook.
Thanks for your help.
I have a very lengthy and complicated VBA code that is currently running through the data entered on one sheet, compiling it on another and then formatting those results onto a mock paper print out that my company uses. What I need is to email those paper forms while still having the option to print. The layout isn't perfect and requires some adjusting and it does change yearly.
I guess what I'm asking is, How do I insert a code (I don't have one) to run automatically after the VBA code runs to compile the reports? I would like them to be attachments that don't need to be saved in an outside folder since all the needed information is readily available in the workbook.
Thanks for your help.