Is there a way to send the current excel sheet or file as an attachment?

[Cmart170]

When I click that hyperlink I want the file to be sent as an attachment to that address.  Is there a way to send the current excel sheet or file as an attachment?  Please help.

[#2]

Yes there is

Click File - Share and then you have the option "Attach a copy instead"

If this is not what you're looking for, please provide some more details.

[#3]

@PascalKTeam 

I have a hyperlink in an excel sheet.  Is there a way to send the current sheet (or entire file) as an attachment using only an email address as a hyperlink?

[#4]

@Cmart170 OK now I see. Yes it's possible but only with VBA (macro)

[#5]

@PascalKTeam Great - However I dont know how to do that.  Do you know where I can go to get HOW TO instructions?

[#6]

It's difficult to give one source for VBA because there's different ways and it also depents on your specific file and your exact requirements.
I think these 2 videos are good but don't expect to know exactly how this is done after watching them.

https://www.youtube.com/watch?v=0k8t2Fy6nSc
https://www.youtube.com/watch?v=A6tggcOV6ts

Dealing with VBA takes some practice.

As an alternative: There's also a non-VBA way with Power Automate: https://www.youtube.com/watch?v=ED11n1o1W7o