I am using Excel 2013 and have a project that needs to send out, via email, two different worksheets from the same workbook. The worksheets are named "Weekly Report" and "Weekly Overview". I have placed a button "Send Report" on the worksheet "Weekly Overview". Can you assist me with a macro that will send the two worksheets as attachments to two individual people when the "Send Report" button is pushed? The people will always be the same recipients.
Thanks, in advance, for your help.