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

%3CLINGO-SUB%20id%3D%22lingo-sub-1880858%22%20slang%3D%22en-US%22%3EIs%20there%20a%20way%20to%20send%20the%20current%20excel%20sheet%20or%20file%20as%20an%20attachment%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1880858%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EWhen%20I%20click%20that%20hyperlink%20I%20want%20the%20file%20to%20be%20sent%20as%20an%20attachment%20to%20that%20address.%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3EIs%20there%20a%20way%20to%20send%20the%20current%20excel%20sheet%20or%20file%20as%20an%20attachment%3F%26nbsp%3B%20Please%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1880858%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1881121%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20way%20to%20send%20the%20current%20excel%20sheet%20or%20file%20as%20an%20attachment%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1881121%22%20slang%3D%22en-US%22%3EYes%20there%20is%3CBR%20%2F%3E%3CBR%20%2F%3EClick%20File%20-%20Share%20and%20then%20you%20have%20the%20option%20%22Attach%20a%20copy%20instead%22%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20this%20is%20not%20what%20you're%20looking%20for%2C%20please%20provide%20some%20more%20details.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1881521%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20way%20to%20send%20the%20current%20excel%20sheet%20or%20file%20as%20an%20attachment%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1881521%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422482%22%20target%3D%22_blank%22%3E%40PascalKTeam%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20hyperlink%20in%20an%20excel%20sheet.%26nbsp%3B%20Is%20there%20a%20way%20to%20send%20the%20current%20sheet%20(or%20entire%20file)%20as%20an%20attachment%20using%20only%20an%20email%20address%20as%20a%20hyperlink%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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.

5 Replies
Highlighted
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.
Highlighted

@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?

Highlighted

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

Highlighted

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

Highlighted
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