up vote 1 down vote favorite
share [g+] share [fb]

Word 2003. Have 4 different Word documents setup, all using the same excel datasource, but the documents have different, logos, text, terms, different columnar content layouts.

Currently remLetter1.doc, remLetter2.doc, remLetter_c1.doc, remLetter_c2.doc each get 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?

link|improve this question
73% accept rate
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
feedback

migrated from stackoverflow.com Jun 25 '11 at 10:13

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

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.