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 / February 2005

Tip: Looking for answers? Try searching our database.

How to protect the main document in a mail merge process

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Antonio Ortiz - 16 Feb 2005 16:41 GMT
I have a main document that needs to print for each id numbers filed in an
Excel Spreadsheet. I'm using mail merge but the problem is that due to
regulatory requirements I need to protect the main document during the mail
merge but if I do so in Word 2002 (MS Office XP Pro) the mail merge function
is not allowed. How can I perform this mail merge process maintaining
protected the main document. Is there is a waork around in Word? Is the new
Word 2003 have this capability? Is there is another MS or third party
software that provide this capabilities?
Doug Robbins - 16 Feb 2005 23:55 GMT
You cannot mailmerge to a protected document.  If you execute the mailmerge
to a new document, you could run a macro over that document that separated
it into individual files and protected each of them.  After all, it is the
result of the mailmerge that should be the issue, not the source.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested.   Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I have a main document that needs to print for each id numbers filed in an
> Excel Spreadsheet. I'm using mail merge but the problem is that due to
[quoted text clipped - 7 lines]
> Word 2003 have this capability? Is there is another MS or third party
> software that provide this capabilities?
Antonio Ortiz - 17 Feb 2005 01:45 GMT
The problem is that the regulatory document is the main one (source) which is
already approved and that I should prevent from inadvertend changes when a
clerk load it to mass print it through mail merge function with the id
numbers on each replication. If not,  somebody will be required to verify
that replications are identical to the source and I don't want to do that and
put it in a written procedure.

> I have a main document that needs to print for each id numbers filed in an
> Excel Spreadsheet. I'm using mail merge but the problem is that due to
[quoted text clipped - 4 lines]
> Word 2003 have this capability? Is there is another MS or third party
> software that provide this capabilities?
Doug Robbins - 17 Feb 2005 02:19 GMT
Then use a macro to perform the mailmerge that contains in it the code to
unprotect the document so that the merge can proceed and reprotect it when
completed.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested.   Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> The problem is that the regulatory document is the main one (source) which
> is
[quoted text clipped - 17 lines]
>> Word 2003 have this capability? Is there is another MS or third party
>> software that provide this capabilities?
Antonio Ortiz - 17 Feb 2005 21:05 GMT
I follow you. I will work on it. Thanks!

> I have a main document that needs to print for each id numbers filed in an
> Excel Spreadsheet. I'm using mail merge but the problem is that due to
[quoted text clipped - 4 lines]
> Word 2003 have this capability? Is there is another MS or third party
> software that provide this capabilities?
 
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.