Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have four different Word 2003 documents set up, all using the same Excel data source, but the documents have different logos, text, terms and columnar content layouts.



each gets opened, setup and run individually.

There must be a simple way to automate the template used for each record, rather than opening each document, setting up the recipient list, and merging four times. It works the way it is now, but really seems like it could be a shorter task.

What would be a way to do this?

share|improve this question

migrated from Jun 25 '11 at 10:13

This question came from our site for professional and enthusiast programmers.

perhaps. This will require vba code so I thought this more likely to garner assistance here. how do you move a question if that is deemed appropriate? – datatoo May 23 '11 at 13:36
you can flag to have your own post closed or migrated by a moderator. MailMerge wouldn't require VBA - it's extremely well-versed in conditional formatting without any code-behind (i.e. use fields in the doc itself). – Otaku May 23 '11 at 18:08
what I am trying to do goes beyond conditional usage of data in merge fields and their formatting. I need to specify a whole document template conditionally. – datatoo May 23 '11 at 19:32
Why can't you setup the mail merge via VBA and choose the template there at the same time? – Adam Oct 13 '13 at 9:50

You must log in to answer this question.

Browse other questions tagged .