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

Question

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

pascalkteam · Answer

Yes there isClick 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.

cmart170 · Answer

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

pascalkteam · Answer

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

cmart170 · Answer

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

pascalkteam · Answer

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=0k8t2Fy6nSchttps://www.youtube.com/watch?v=A6tggcOV6tsDealing 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

Forum Discussion

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

5 Replies

Resources