VBA Code to automatically complete mail-merge document for upto 200 recipients

etcib · #3 04-23-2018, 12:38 PM

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!?!?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Recipients can not view the inserted object (PDF) from my mail merge document	Stacy	Mail Merge	1	02-26-2015 11:24 PM
Mail Merge only sends to a select amount of recipients.	Lb145	Outlook	2	05-07-2014 02:06 AM
Mail Merge only sends to a select amount of recipients.	Lb145	Mail Merge	11	05-06-2014 03:15 PM
mail merge multiple recipients per page	bmobrien	Mail Merge	3	02-23-2012 10:47 PM
Mail Merge Recipients List	TanMan	Mail Merge	1	10-13-2011 06:36 PM