Reply
 
Thread Tools Display Modes
  #1   Report Post  
Gracia
 
Posts: n/a
Default Can I use "Protect Document" in a merge form?

I've created a document to merge data from an Excel spreadsheet. I'd like to
"protect" the document so that users can tab from checkbox to checkbox to
mark them appropriately. Is this possible
  #2   Report Post  
Charles Kenyon
 
Posts: n/a
Default

Not easily done. A completed merge will strip out formfields leaving you
with symbols rather than active checkboxes. If your users can check the
boxes before the merge and then unprotect the document it works. Otherwise,
if you are only merging a single record you can link up the merge to the
record, display it on the screen, unlink the merge fields, and protect your
document. That is easier to say than it is to do and it isn't easy to say.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Gracia" wrote in message
...
I've created a document to merge data from an Excel spreadsheet. I'd like
to
"protect" the document so that users can tab from checkbox to checkbox to
mark them appropriately. Is this possible



  #3   Report Post  
bet_saliz
 
Posts: n/a
Default



"Charles Kenyon" wrote:

Not easily done. A completed merge will strip out formfields leaving you
with symbols rather than active checkboxes. If your users can check the
boxes before the merge and then unprotect the document it works. Otherwise,
if you are only merging a single record you can link up the merge to the
record, display it on the screen, unlink the merge fields, and protect your
document. That is easier to say than it is to do and it isn't easy to say.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Gracia" wrote in message
...
I've created a document to merge data from an Excel spreadsheet. I'd like
to
"protect" the document so that users can tab from checkbox to checkbox to
mark them appropriately. Is this possible




  #4   Report Post  
bet_saliz
 
Posts: n/a
Default

In WordPerfect I could create templates that let me select addresses from the
Corel address book with fill-in fields. I'm trying to do something similar in
Word using templates, merge and form tools, but so far, it doesn't work too
well. Any suggestions, or am I wasting my time?
  #5   Report Post  
Charles Kenyon
 
Posts: n/a
Default

With the mail merge toolbar's find record and select records buttons you can
do this as part of a merge. You could use Outlook as your source or a
separate data file. I use an Excel worksheet that lists my clients and
cases. My merge form pulls client name and address, prosecutor name and
address, clerk of court address, and/or judge name and address for letters
and other case-specific info for pleadings.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"bet_saliz" wrote in message
...
In WordPerfect I could create templates that let me select addresses from
the
Corel address book with fill-in fields. I'm trying to do something similar
in
Word using templates, merge and form tools, but so far, it doesn't work
too
well. Any suggestions, or am I wasting my time?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge Document and Fill in Form (Word 2000) t0kein Mailmerge 5 April 6th 05 05:42 PM
How can I protect a form and still have mail merge? Beth Mailmerge 1 March 12th 05 04:41 AM
How to protect the main document in a mail merge process Antonio Ortiz Mailmerge 4 February 17th 05 09:05 PM
How to protect the main document in a mail merge process Antonio O Mailmerge 0 February 16th 05 04:29 PM
Can I use a form template document for mail merge? Just Checking Mailmerge 1 December 14th 04 10:27 PM


All times are GMT +1. The time now is 12:27 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"