I have a membership list of addresses, column "P" contains the amount paid, "R" contains "EMAIL" or "POST" choice, (as text), and "S" contains the date of entry (automatically generated on entry of amount paid).
A letter is sent out after payment to say if they will receive the newsletters by "EMAIL" or "POST", at present I have to select the row of adresses to print manually.
I would appreciate help being able to print rows of addresses of people who receive their newsletter by "EMAIL" and then a different letter to those by "POST". I would prefer VBA Code rather than Sort or Filter etc.
I have the printing bit done ok but am not able to select the choice from the cells.
Regards
Roger M
A letter is sent out after payment to say if they will receive the newsletters by "EMAIL" or "POST", at present I have to select the row of adresses to print manually.
I would appreciate help being able to print rows of addresses of people who receive their newsletter by "EMAIL" and then a different letter to those by "POST". I would prefer VBA Code rather than Sort or Filter etc.
I have the printing bit done ok but am not able to select the choice from the cells.
Regards
Roger M
