View Single Post
  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

Don't save the macros in the document. Save them in the document template.
If they are not in the document, they will not be mailed with it.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Widmer wrote:
I've developed some nice little macros in a letter template which
add/remove our company logo, add/remove footer text, shift the
recipient's address into the proper position when creating a letter
which will be sent in a window-envelope, etc. These functions are
called from custom menus in Word which call the respective macros
stored in a module within the template/document.

Two problems with our "Macro" solution:

1.) Letters created with this template are sometimes e-mailed
externally. We don't want recipients to have any of the programmed
functionality, just the text. Basically, our employees need the
programmed functionality as long as the documents are in-house.
External recipients do not.

2.) Macros are being detected internal and external mail servers as
"Macro viruses".

I'd rather not have the authors remember to delete/remove macros
before e-mailing Word files.

I've seen some programs (like PDFMaker) in Word's tool bar, and I
noticed that it is using some of its own macros, but the macros are
stored in each PC's local "Microsoft Office/Office/startup" folder,
and not stored with the document itself. After briefly experimenting
with the startup folder, I couldn't duplicate this "local only"
functionality. Is there some other technology required such as COM or
ActiveX? Or, does anyone recommend using Visual Studio Tools for
Office instead of Word's VBA environment? Is there an advantage?