alexfwalker81
Member
- Local time
- Yesterday, 20:19
- Joined
- Feb 26, 2016
- Messages
- 93
I use a database to import data, which is then validated and reformatted. At present, the information is exported to Excel, which is then imported into Word in a MailMerge. I use a plugin in Word called 'Split the Merge' (or something like that), which takes my MailMerge and saves individual documents or PDFs. This is so that I have a separate entry for every line in my database table. Possibly a niche thing to have to do, but the context is that each line in the table is an ingredients list for a product, so each product then has its own output sheet. As you can see though, it's inelegant and has a few inherent limitations.
What I would like to be able to do is skip whole Excel > Word > Mail Merge bit. This is easily achieved by simply writing a report in Access which looks the same as my Word Mail Merge template. I can export this report in PDF format to wherever I like. However, the bit that I don't know how to do is do a separate report for every line in my table.
I'm thinking that I'd need a function to loop through each line a query or table, exporting a PDF each time, until it gets to the end. I just don't know how on earth to do that...
What I would like to be able to do is skip whole Excel > Word > Mail Merge bit. This is easily achieved by simply writing a report in Access which looks the same as my Word Mail Merge template. I can export this report in PDF format to wherever I like. However, the bit that I don't know how to do is do a separate report for every line in my table.
I'm thinking that I'd need a function to loop through each line a query or table, exporting a PDF each time, until it gets to the end. I just don't know how on earth to do that...