Greetings. Like the fine folks in these two threads:
I have a report that is 512 pages or so. The unique field name on each page is STORE. I have a hierarchy in another table that has each store number and an email address. Based on what I see above I can loop through each record/page, create a one page PDF and send that page to each store email address. Next though I have to 'roll up' the pages based on the higher levels. so 20 stores belong to 00001, then all the stores in 00001, 00002, 00003 are part of 00010, etc.
Assuming that where the code is doing a vlookup kind of action (I'm an excel guy by trade) with the store number to the email, we should be able to do the same thing right? to say that if a store is part of 000001, then group all those pages together, create the pdf file and email to the corresponding address.
Thanks in advance-