Mail-Merge on Steroids: Can Word 2003 do this?

Posted by richardtallent on Super User See other posts from Super User or by richardtallent
Published on 2010-10-18T18:30:06Z Indexed on 2012/07/08 3:18 UTC
Read the original article Hit count: 221

I have a huge report to put together, made up of over 1,000 smaller, nearly-identical reports.

Each report includes:

  • General 1:1 information (basic mail-merge stuff)
  • Lots of text, some of which may need to be disabled or have alternate text based on a boolean field.
  • A few embedded images, preferably loaded via HTTP URL, but if they have to be on the a file system thing I can do that. (Filenames will be provided as a field in the data source.) Fortunately, all images are roughly the same size/shape.
  • Several 1:m tables with a few fields apiece.

The kicker is the master/child tables. I've seen examples for Word 2000 for doing this by left-joining the master and child table and using some IF/THEN logic to know whether to jump to the next master record. But in my case, I have several of these subtables, so that approach won't really work.

So, can Word 2003 handle arbitrary master/child tables? If so, how?

If not, I considered InfoPath, but I haven't used it before, and it seems to be made for data entry, not long formatted reports.

I'm a software developer, so I could always hack something together with a massive VBA macro, or generating the report in HTML on the web server (where the data is coming from anyway). But I'm hoping Word will work without such gymnastics, since it will give the ultimate users of the report template better control over formatting and making minor changes.

© Super User or respective owner

Related posts about microsoft-word

Related posts about Xml