Quote:
Originally Posted by macropod
You should indeed create the mailmerge main document with all the boilerplate text and field coding you require. Trying to code all this into a macro will end up generating something that's a nightmare to maintain. User's really shouldn't have any difficulty opening the mailmerge main document, answering 'Yes' to the SQL prompt, then finishing the merge. If you're wedded to the mailmerge being run from Excel, the mailmerge main document that you do the set-up on could then be automated.
|
Thanks,
I know it is easy generate the mailmerge using the options through word/publisher, however I have been tasked to try and make the process 'bulletproof'. The excel sheet created and merged documents need to be used by upwards of 50 members of staff, most of which have very basic (if any) concepts of using a computer beyond typing a word document.
I've taken bulletproof to mean 'can you create a button which will automatically generate the merge documents so that these *idiots* won't be able to do it incorrectly...'
At the minute I use a publisher template just because I found inserting the fields (nearly 100 of them at most so far) a whole lot quicker than in word.
Any ideas to make it bulletproof so that the incompetent colleagues don't get too confused!?!?