Discussion Locked

Word 97 Mail Merge Required Fields

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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!

5 replies

by dklippert

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.

by sginsc

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

by garlin

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.

by sginsc

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.

This discussion is closed to new replies.