palmpasob.blogg.se

• MAIL MERGE WORD FOR MAC WITH EXCEL CORRUPT UPDATE

Is there anything else you can describe here to give a better understanding of what happens next WITH the individual records.Do these weekly "report cards" get used themselves as the basis for additional data entry?.

MAIL MERGE WORD FOR MAC WITH EXCEL CORRUPT UPDATE

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?.Once you have all 50+ report cards, are they static?.So I apologize but I feel responsible for trying to ensure that you're using Excel 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. I ask these questions not to be impertinent, but because in my experience with Excel and with seeing others use it, I'd say it's not uncommon that people will create a lot of individual records that end up actually getting in the way of really using Excel well. What are you proposing to do with the individualized (or mail-merged) sheets once they're created? I (for one) would first be wanting to know why you want to populate 50+ individual sheets with all that data rather than continue to build a single database that can at any time be used to populate another sheet for a nice looking printout. But what, I wonder, is that reason? Why not just create them one at a time as needed? If, on the other hand, you need to show these records for some reason in an Excel format (if, that is, the row and column set up is integral with your goal) then, yes, it would be fairly easy to do using one of several LOOKUP functions or INDEX and MATCH as the basis for extracting the various fields and populating the target sheet. If you're really creating a form letter (as opposed to just using that as an analog) then Word's Mail Merge, with Excel as the data source, would be the way to go. My help will come in the form of questions.įirst, what is it that you are really looking to accomplish at the end of all this? Do you really need 50+ copies of the same spreadsheet, each populated by one of 50+ different records? That doesn't sound very efficient.