I moved a process where Microsoft Word is normally used into Excel. In a nutshell, I have 80 or so letters, each representing a different client, that are sent weekly. Each week, not every client gets a letter and there are only small differences between each letter (address, name, amount, etc.). I've set a print area of all 80 letters.
As mentioned, not every letter is sent so I've come up with a way to filter out those letters that aren't to be sent. Now, I want to print the letters that are showing (i.e. survived the filter and are showing). How do I do this b/c a print preview shows all 80 printing even though most are hidden because of the filter?
Thanks!
As mentioned, not every letter is sent so I've come up with a way to filter out those letters that aren't to be sent. Now, I want to print the letters that are showing (i.e. survived the filter and are showing). How do I do this b/c a print preview shows all 80 printing even though most are hidden because of the filter?
Thanks!
