Send Single Sheet from workbook as outlook attachment

[Karlos588]

I'm new to VBA and i'm trying to build a macro that will at the click of the button, save the single spreadsheet in a specified folder with the name 'Accruals (current month) 2020, once it has done this, I then need it to open outlook with default wording and attach?

Is this possible? I've tried a few Macros, but i'm not having much luck.

I've Uploaded an example from my Spreadsheet, This is the Sheet i want to split each month under a new name and email.

Thanks in advanced

[TMS]

Have a look at Ron de Bruin's web site. Everything you need to know about integrating email.

[Karlos588]

Brilliant! Thanks for the Tip, I'm Sorted Now!

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.