Microsoft Office Forums - View Single Post - [Solved] Select multiple entries from a list

macropod · 10-26-2017, 02:29 PM

I'm not sure what you mean by 'add multiple clients all at once'. All 2200 clients would be added to the dropdown - a monstrous thing to scroll through to find an entry - and you could only select one. Unless a different approach were taken or the remaining entries were deleted, the resulting document would also be permanently bloated with a dropdown list containing nearly 2200 redundant entries.

Frankly, for what you're trying to do, you'd be better off sticking with mailmerge and either:
1. Using a SKIPIF field coded along the lines of either:
{SKIPIF {MERGEFIELD AccountNumber}<>{FILLIN "Account Number # to process" \o}}
or:
{SKIPIF «AccountNumber»<>{FILLIN "Account Number # to process" \o}}
if all you want to do is process a single account at a time, or:
2. Using the mailmerge filters to select multiple accounts for processing at a time.

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. Likewise, the chevrons (i.e. '« »') are part of the actual mergefields - which you can insert from the 'Insert Merge Field' dropdown (i.e. you can't type or copy & paste them from this message, either). The spaces represented in the field constructions are all required.