hi, i really don't know which forum this would go under, maybe you could direct me where to put it.

I have an address book in excel with some extra information that lists clubs that my entries are in and meeting dates for specific members. when a specific date approaches, I have a word document that has blank fields that auto populate from the information in excel (address field, name field, meeting date field, club name field, etc...)

what currently happens now is that if someone is in multiple clubs, they receive 1 letter for each club. in the excel sheet, is there a way to list multiple club names on one row but using only one cell (or is as easily remedied as listing multiple clubs in once cell separated by a comma or semicolon)? kind of like a drop down menu when you hover your mouse over the cell or click on the cell? so that on the word document, instead of getting 5 newsletters for 5 clubs, I can have one newsletter go to one member with another empty field that populates if they belong to multiple clubs?

does this make any sense?