Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2005

Tip: Looking for answers? Try searching our database.

VBA & Mail merges

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Clarkie - 11 Apr 2005 14:34 GMT
I have a userform with vba macro's in it, but when I
perform a mail merge and save the results as a new
document, the macro's have been lost.

Is there any way round this ?
Peter Jamieson - 12 Apr 2005 11:38 GMT
Yes, some parts of a document are replicated during a merge but others are
not. If all you need to be able to do is use the same macros on the machine
that did the merge, you should be able to put the macros in the template
attached to the merge document (ideally do not use normal.dot in this case).
The merge output document should be attached to the same template and the
macros should be available.

Peter Jamieson
>I have a userform with vba macro's in it, but when I
> perform a mail merge and save the results as a new
> document, the macro's have been lost.
>
> Is there any way round this ?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.