I have a list of membership numbers of approx 80 people. I need to use these numbers (saved in an excel spreadsheet) to run a report in Civi which will pull all the addresses and names linked to those numbers (with the number) into a new excel sheet which I will then use for a mail merge.
When in Civi I can see that you can import a spreadsheet but that seems to be to add new members. What I need is not to add memberships/individuals but to use the numbers to collate information linked to those numbers already in Civi.
Can anybody help with the best way to do this without adding any duplicate information to Civi, or manually typing/searching all 80 people?
Thanks in advance.