Hi,

This is my first post.

I am creating a form for a friend. The upper portion of the form is a
merge data imported from excel. The problem is I can can not import the
data unless the document is unprotected. If I were to unprotect the
document then there is a chance my friend will revise the form which I
do not want to happen.

How can I merge a data from excel into WORD 2003 when the document is
protected? Please help.

Thanks,
Bernie


--
benno
------------------------------------------------------------------------
benno's Profile: http://www.highdots.com/forums/m929
View this thread: http://www.highdots.com/forums/t3007660

Try using the following macro

Sub MailMergeToDoc()
'
' MailMergeToDoc Macro
' Collects the results of the mail merge in a document
'
Dim mmmdoc As Document
Set mmmdoc = ActiveDocument
If ActiveDocument.ProtectionType = wdAllowOnlyFormFields Then
ActiveDocument.Unprotect
WordBasic.MailMergeToDoc
ActiveDocument.Protect wdAllowOnlyFormFields
mmmdoc.Protect wdAllowOnlyFormFields
End If

End Sub


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"benno" wrote in message
...

Hi,

This is my first post.

I am creating a form for a friend. The upper portion of the form is a
merge data imported from excel. The problem is I can can not import the
data unless the document is unprotected. If I were to unprotect the
document then there is a chance my friend will revise the form which I
do not want to happen.

How can I merge a data from excel into WORD 2003 when the document is
protected? Please help.

Thanks,
Bernie


--
benno
------------------------------------------------------------------------
benno's Profile: http://www.highdots.com/forums/m929
View this thread: http://www.highdots.com/forums/t3007660