How to generate Automatic form in excel (mail merge)?

Nancy1231820 

There still are a few lingering question (doing this by exchanged messages is so much harder than in a face-to-face meeting!) at least there are questions dangling in my mind.

• Once you have all 50+ report cards, are they static?
• OR: Do they update each week with new data in the master database, and need to be printed or otherwise distributed on a regular basis?
• Do these weekly "report cards" get used themselves as the basis for additional data entry?
• Is there anything else you can describe here to give a better understanding of what happens next WITH the individual records

Now, all of those questions having been asked, I can envision at several scenarios, depending on your answers to the above.

• If in fact the 50+ report cards, once generated, are basically static--don't change themselves--then it would be easiest, I'd think, to just create a "dashboard" kind of sheet, formatted as you would for utility and clarity, a sheet that uses one of the several LOOKUP functions to populate the various fields, and run through them manually once, printing them out.
• If, on the other hand, you're updating the master database each week (or some regular and ongoing basis), then a macro could be written (by somebody else; it's been too long since I did that, although I have, but maybe 25 years ago), a macro that would run through the database and print each one anew each time they're updated
• If you really just want them in Excel (not printed), and for some reason still not clear to me want all 50+ to be each on their own tab, used only to look at...{ well, if it hasn't been clear yet, I question that; it's just so easy to pull up as needed any one of them in a single sheet designed specifically for that purpose
  • UNLESS you're actually using all 50+ to collect individualized data on them rather than in the master database. And if that's the case, I'd question that too;
    • it's always cleaner to collect (Input) data in the database;
    • and display it in some Output sheet (such as the aforementioned "dashboard")

All of which is to say, I still don't have the bigger picture here and am wanting to get there. My questions are not meant to be difficult--however they might be perceived--but to get us to the point where we do can achieve the most functional approach to these "report cards."