Macros deleted when emailed

J

J. Verburg

Hi,

I have a few templates with two macros in them. When I mail a document based
on one of these templates to someone else, it arrives without macros. I
suspected the anti-virus of deleting them, but even with anitvirus disabled
(on server, sending client and receiving client), the macros do not survive
mailing.

Where should I look for a way to fix this?

Jeroen
 
J

Jonathan West

Documents based on a template do not include its macros. This behavior is
different from Excel, where macros are included.

In Word, the macros are accessible to you when you create a new document
because the document includes a reference to the attached template. When you
email the document to someone, the template is no longer available.

There are two possible approaches.

1. Send the template as well.
2. Copy the macros into the document.

I would recommend the first approach. Security considerations are such that
most people have Word set up so that macros embedded in documents are
automatically disabled.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
 
S

Stefan Blom

You have to send not only the document, but also the template to your
recipients. Word macros in a template are *not* copied into documents
created from that template.

--
Stefan Blom
Microsoft Word MVP


in message
news:[email protected]...
 
J

J. Verburg

Well, thanks for that explanation. I now understand why it seemed to work
when I mailed the document to myself!
One question to follow up: I guess the receiver would have to save the
template in his templates folder? Probably just having it in his inbox would
not be enough...?

Jeroen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Synchronization problems while moving folders to new email 1
Enabling Macros message when NO macros in workbook 3
Email that ends up in sent folder is not delivered to recipients 3
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
Can defaults be overriden by macro code? 0
Macro doc + toolbar button via Email? 5
Getting macro template to work in Vista? 3

Top