Merging Excel to Word and Powerpoint

It is not difficult to merge Excel data to Word documents, but this destroys the bookmarks, and if you find you want to redo the merge after you've substantially modified the Word document, that can be frustrating. I wanted a merge that could be repeated as often as required, which meant recreating the bookmarks after the copying was done.

Powerpoint is much more difficult because it has no bookmarks, and it doesn't even let you name the objects on a slide so you can address them in code...

Click to expand...