Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I merge a data from excel into WORD 2003 when the document is protected?
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel data truncated to 255 chars in Word Mail Merge | Mailmerge | |||
Mail Merge of a Date from Excel Data into Microsoft Word | Microsoft Word Help | |||
insert Excel data into Word Mail Merge document | Mailmerge | |||
Merge data in Excel Spreadsheet into a word document | Mailmerge | |||
Excel worksheet in Word linked text boxes | Page Layout |