Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

Currently

remLetter1.doc  
remLetter2.doc  
remLetter_c1.doc  
remLetter_c2.doc  

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 stackoverflow.com 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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.