As Andrew affirms a merged document will not contain macros. If you wish to explore his suggestion of sending a macro enabled document or macro enabled template with a covering message, you could investigate
E-Mail Merge Add-in, however the attachment will not contain your merged data. What was the purpose of the macro?