I generate a report in Access 2007 regularly that needs to be converted to Word. No problem there.
I also have a standard/template set of Powerpoint slides that need to hyperlink directly to specific pages in that Word document.
My thought is to generate the report in Access, export to Word and run some sort of code that will automatically go through word looking for the first line in the report (which contains the customer name) to create a bookmark at the customer name that is the customer's name with spaces removed. The customer names rarely change (so my PowerPoint hyperlinks should be able to point to the same bookmarks in the word document, no problem), it's just the metadata for the customer that changes.
I thought the geniuses here at Experts could tell me if there is a better way of accomplishing my goal (which is to automatically regenerate the bookmarks every time in my report)... perhaps something I could put in the database to create the bookmark?
If you think the Word code is the best bet, I need help creating that code; i have no idea how to create a bookmark in code.