Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge with text box in letter
I have a mail merge document that has a text box in it for the user to enter
a specific date. I can't use the Fill-in field b/c when the msg box appears for the user to enter the date, it locks up their computer. When I protect the document, to allow auto-entry for that text box nothing is then available, including the mail merge feature. Any suggestions? Sorry if these is confusing or doesn't make sense! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge with text box in letter
Which version of Windows and Word?
Is this Mailmerge document being loaded by another application (e.g. using automation) ? Does an ASK field cause the same problem? To use ASK, you need something like { ASK mybookmark "prompt text as in the fillin field" }{ REF mybookmark } where the {} are all the special field code braces you can enter using ctrl-F9 If your FILLIN field is asking for a value /once/ at the beginning of the merge (i.e., uses the \o switch) then the simplest alternative is probably to use a small piece of VBA to a. prompt for the text b. set the value of a Word Document Variable c. start the merge At its simplest, it could be something like Sub myfillin() Dim strFillin As String Dim objVariable As Word.Variable strFillin = inputbox("Prompt string from your FILLIN box", "Dialog box title", "Default value") If strFillin = "" Then strFillin = " " On Error GoTo varexists ActiveDocument.Variables.Add Name:="myvar", Value:=strFillin GoTo varcreated varexists: ActiveDocument.Variables("myvar").Value = strFillin Err.Clear On Error GoTo 0 varcreated: ActiveDocument.MailMerge.Execute End Sub You would need to provide the user with a button to invoke the macro. You would include the result of the Document Variable using a { DOCVARIABLE myvar } field in the document. If your FILLIN field asks the user for a value for each record in the data source, you can't use that approach. Peter Jamieson "Lori Ann" wrote in message ... I have a mail merge document that has a text box in it for the user to enter a specific date. I can't use the Fill-in field b/c when the msg box appears for the user to enter the date, it locks up their computer. When I protect the document, to allow auto-entry for that text box nothing is then available, including the mail merge feature. Any suggestions? Sorry if these is confusing or doesn't make sense! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge with text box in letter
A couple of other things...
a. are you sure that the FILLIN+text box combination is locking up the computer? Where is the text box? Is it in the body of the text, or in a header/footer? Is the FILLIN dialog preventing anything else from happening at all? If you do not use the \o switch in the FILLIN field the FILLIN dialog box will appear for every record in the merge data source, and that can make it appear as if the FILLIN box is "stuck" b. Have you tried converting the text box to an old-style Word frame (select the box, right-click, Format Text Box|Text Box|Convert to Frame) Peter Jamieson "Lori Ann" wrote in message ... I have a mail merge document that has a text box in it for the user to enter a specific date. I can't use the Fill-in field b/c when the msg box appears for the user to enter the date, it locks up their computer. When I protect the document, to allow auto-entry for that text box nothing is then available, including the mail merge feature. Any suggestions? Sorry if these is confusing or doesn't make sense! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I mail merge to EMAIL from MS Word AND add a pdf attachment | Mailmerge | |||
Mail Merge doc that needs to have a text box for date fill-in | Mailmerge | |||
Images, Mail Merge and Text Boxes | Mailmerge | |||
Can't get Word 2003 to keep data file with mail merge main documen | Mailmerge | |||
Convert to Symbols | Microsoft Word Help |