Forum

Send single sheet b...
 
Notifications
Clear all

Send single sheet by mail with outlook

2 Posts
2 Users
0 Reactions
70 Views
(@bogi)
Posts: 9
Active Member
Topic starter
 

Hi

I have a workbook containing many worksheets. I would like to send one sheet by email attachement via Outlook.

The filename should be the sheet name

The email should be sent by command button

And if possible the file that is sent will not include the VBA code

Is there her someone who can help me to Write the VBA code

 

Thanks for Your help

Bogi

 
Posted : 18/08/2020 7:51 am
Anders Sehlstedt
(@sehlsan)
Posts: 968
Prominent Member
 

Hello,

Have you read this blog post? It should help you with what you want.
https://www.myonlinetraininghub.com/vba-to-create-pdf-from-excel-worksheet-then-email-it-with-outlook

Br,
Anders

 
Posted : 18/08/2020 11:06 am
Share: