I think there is nothing to with the macro security, rather you want to check
your firewall settings or setting in the web browser like IE.
many firewalls remove the embedded macros from Excel/Word files when send as
an email attachments. also you might want to check your mail client settings,
like Outlook etc.