General discussion

Locked

Word 97 Mail Merge Required Fields

By SGinSC ·
In Word 97, is there a way to make a mail merge field a required entry? I cannot find any references to special switches, codes, etc. to prevent a user from producing a document without entering certain information.

I have heard this could be done with a macro or other coding. A solution not requiring any coding is preferable, but any solution would be acceptable.

Thanks in advance for any help!

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Word 97 Mail Merge Required Fields

by DKlippert In reply to Word 97 Mail Merge Requir ...

One of the easier solutions might be to use Excel or Access as your data source. Both of those applications have the facility to require entries.

Collapse -

Word 97 Mail Merge Required Fields

by SGinSC In reply to Word 97 Mail Merge Requir ...

This is helpful to know, but we have to keep the solution with Word. Thanks for your input, though.

Collapse -

Word 97 Mail Merge Required Fields

by Garlin In reply to Word 97 Mail Merge Requir ...

Option 1. Set up a conditional field that will substitute a default value if the supplied value is missing. Use = to assign the value to a bookmard, and use IF or Compare to compare it to a "".

Option 2. Open the merge source file in Excel beforethe merge. The fields should be organized into columns. It should be easy to find the blank cells. You can either fill them and then use the excel file as your merge source, or reject the input from the user and have him recreate it correctly.

Option 3. Use SkipIf to skip the record if it fails to meet certain conditions, like have all the required fields.

Collapse -

Word 97 Mail Merge Required Fields

by SGinSC In reply to Word 97 Mail Merge Requir ...

Thank you! Option 2 won't help because we need to keep the solution within Word, but I think Options 1 and 3 will help.

Collapse -

Word 97 Mail Merge Required Fields

by SGinSC In reply to Word 97 Mail Merge Requir ...

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums