Use excel to drive dropdown list in pdf

[knigget]

I have a list of items in a spreadsheet which are maintained by a designated person to ensure they are current and applicable.

I have created a pdf form which is pretty much empty apart from simple things like an email address, logo.

I want a different designated person to open that form and, from a drop-down, select the relevant items (could be multiple). They will then save/print that pdf. When that pdf is opened, it only displays the previously selected items - it is no longer a form so the drop-down is gone.

I've looked and looked and can't find anything that I can hack to something usable. Where to begin? I suppose this would be a type of report - can it be done without Access/ database?

Thanks in advance

 

[ranman256]

use excel, or access, put all pdf's in a list,
user can select multiple pdf's from the list to print.

use vb to cycle thru the list printing the ones picked.