A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can macros be retained in an emailed Word document?



 
 
Thread Tools Display Modes
  #1  
Old May 5th, 2010, 08:51 PM posted to microsoft.public.word.docmanagement
momofblam
external usenet poster
 
Posts: 1
Default Can macros be retained in an emailed Word document?

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?
  #2  
Old May 5th, 2010, 11:32 PM posted to microsoft.public.word.docmanagement
Gordon Bentley-Mix[_4_]
external usenet poster
 
Posts: 42
Default Can macros be retained in an emailed Word document?

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" wrote in message
...
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?


  #3  
Old May 6th, 2010, 12:11 AM posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default Can macros be retained in an emailed Word document?

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" wrote in message
...
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" wrote in message
...
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?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:46 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.