Howdy I do love setting myself a challenge but this one I need some help on. I have a spreadsheet containing products and the supplier email address for each product. All suppliers will appear multiple times. The list has thousands of products and hundreds of suppliers. I want to be able email any supplier still on the list after I filter it with a list of their products I need details on. I know MS Word can mail merge off Excel but it will only do 1 email per product line, some suppliers I buy hundreds of products off, that would be alot of emails to them!! Open to suggestions
Something along these lines? https://support.microsoft.com/en-au...create-a-list-sorted-by-category-in-word-2000