Forum Discussion
How to send a macro enabled file by email
Hans,
After the transfer to a colleague failed, I tested the steps internally to another user here at home.
I created an email and attached the file that contained macros.
Then I opened the received file on the other computer, and looked for the embedded macros. Nothing there.
As I read the MS information, Microsoft now puts a note in all files sent over the internet such that macros cannot be accessed on receipt.
Douglas
Macros from the internet will be blocked by default in Office explains how to enable macros that have been blocked.
- Douglas0077Aug 21, 2023Copper Contributor
Thanks for the link.
Things don't quite work as promised.
When I opened the file on the recipient computer, it did not display the warning "Security risk...."
So I had no opportunity to accept the risk from the embedded macros.
On both the recipient computer and on my own computer (where I created the file, and the macros work) the option to unblock the security is not offered. See image.
- HansVogelaarAug 21, 2023MVP
Hmm... Does anyone else know how to solve this?