Forum Discussion
not printing cells based on data in another cell
Think I will try the mail merge, This a N&A list for our community and will want to run a new list every quarter or so.
Never used mail merge before wish me luck.
Mail Merge, in Word, with an Excel database (which is what you have) as the source, can be a very powerful and useful tool.
To make the IF-THEN aspect of this easier for you, I've created some new columns that take the conditions you specified and fill in HomePhone4Print, CellPhone4Print, etc., using the conditions you've described. So you can just use Mail Merge to print those fields, and rely on the formulas in Excel to only show data that people are willing to share.
Note, I added a column with what's called Data Validation, to enter the three conditions in just a single shorter word. This made it possible to have the IF function in my new columns less "wordy."
I assume, from the fact that you refer to addresses, that your real database has mailing addresses as well as all of these bits of info......I hope you can follow the logic in the formulas that are here to incorporate those additional elements.
- Thank you for the additional info and formulas in the excel. Question I have is about the extra field for the 3 types of conditions, is there a formula to create this or did you key it manually?
I understand the 4print fields formulas, I worked in IT for over 45 years, but on mainframes 360/20-30, then system 38, as400, ISeries. Did little PC database programming, mostly RPG and DB2 using DBU and DFU and IBM Query. Just never had time to become a expert in Excel, Access or Word.
Will work on your tips and formulas and try and create the mail merge, will let you know how I make out.
Thanks Again
FrankThat cell with the three conditions uses Data Validation. There are several ways to create the criteria for what's "valid" and several ways to use it. HEre's a great source for instruction on what it is and how to use it. https://exceljet.net/excel-data-validation-guide
Feel free to come back with questions on that or any other item.