Forum Discussion
Is there a way to send the current excel sheet or file as an attachment?
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.
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.
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.
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?
Cmart170 OK now I see. Yes it's possible but only with VBA (macro)
PascalKTeam Great - However I dont know how to do that. Do you know where I can go to get HOW TO instructions?
- 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