I came across this VBA post that allows me to create an email and BCC a list of emails, however I want to gather the visible filtered list, and not everything that is within the range.
I'm unsure where SpecialCells(xlCellTypeVisible) would apply. Any assistance would be appreciated:
Sub...