Can macros be retained in an emailed Word document?
in [Document Management]
|
From: momofblam on 5 May 2010 15:51 I have added some macros to a template for other people to use. I tested sending the document with the macros as an attachment to an email to myself, and the macros were retained, but when I sent the document attached to an email to someone else, the macros were not imbedded in the document. Is there some way to correct this, or will I have to save the document with the macros on our network in a directory accessible to all who want to use it?
From: Gordon Bentley-Mix on 5 May 2010 18:32 I suggest you take a bit of time and read up on how macros and template actually work. The behaviour you describe is not at all unexpected as the document you emailed to yourself will still be attached to the template located on your computer. Of course, anyone else you email the document to won't have a connection to your computer, so this attachment will be broken - in spite of what Word might tell you to the contrary. There are a variety of ways around this, but the "best" solution depends on several factors. I noticed you mentioned a network, so perhaps you can save the template in a location that all users have access to and make sure that any documents you distribute are created solely from that template (and not the one on your computer). Of course, you still have to overcome the issue of macro security, but that's a separate discussion. -- Cheers! Gordon Bentley-Mix "momofblam" <momofblam(a)discussions.microsoft.com> wrote in message news:9F43F1B8-C414-4E52-A59C-5D9E480F0C35(a)microsoft.com... > I have added some macros to a template for other people to use. I tested > sending the document with the macros as an attachment to an email to > myself, > and the macros were retained, but when I sent the document attached to an > email to someone else, the macros were not imbedded in the document. Is > there > some way to correct this, or will I have to save the document with the > macros > on our network in a directory accessible to all who want to use it?
From: Suzanne S. Barnhill on 5 May 2010 19:11 To add to what Gordon has said, macros can be stored in a document instead of in the template. Macro security issues would still be a problem, however. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Gordon Bentley-Mix" <gordon(a)NOSPAM.exmvps.org> wrote in message news:F003CB2F-9C51-4C64-8284-1D5E16347370(a)microsoft.com... >I suggest you take a bit of time and read up on how macros and template >actually work. The behaviour you describe is not at all unexpected as the >document you emailed to yourself will still be attached to the template >located on your computer. Of course, anyone else you email the document to >won't have a connection to your computer, so this attachment will be >broken - in spite of what Word might tell you to the contrary. > > There are a variety of ways around this, but the "best" solution depends > on several factors. I noticed you mentioned a network, so perhaps you can > save the template in a location that all users have access to and make > sure that any documents you distribute are created solely from that > template (and not the one on your computer). Of course, you still have to > overcome the issue of macro security, but that's a separate discussion. > -- > Cheers! > > Gordon Bentley-Mix > > "momofblam" <momofblam(a)discussions.microsoft.com> wrote in message > news:9F43F1B8-C414-4E52-A59C-5D9E480F0C35(a)microsoft.com... >> I have added some macros to a template for other people to use. I tested >> sending the document with the macros as an attachment to an email to >> myself, >> and the macros were retained, but when I sent the document attached to an >> email to someone else, the macros were not imbedded in the document. Is >> there >> some way to correct this, or will I have to save the document with the >> macros >> on our network in a directory accessible to all who want to use it? >
|
Pages: 1 Prev: Word 2003 SP3 - Spell Check Next: How do I scan in a form for entries and changes? |