Mail Merge keeping VBA Macro

macropod · #1 08-02-2015, 10:41 PM

Quote:

Originally Posted by Piney

I am not building this into the mail merge because I am creating a report for a client. The mail merge contains my intellectual property so I do not want them to have access to this. They will then conduct interviews and rate candidates (using the radio boxes) which then modifies an 'Overall Rating' further down the report.

In which case, why use mailmerge at all? It seems to me the entire process could be driven from a macro-template to populate the document, which could use formfields and such other fields as you need to calculate the ratings. That avoids the problem of your clients potentially having macros disabled (deliberately or otherwise) when they use the form.

Piney · #2 08-02-2015, 11:57 PM

I see where you are coming from but the nature of my field requires are lot of input and calculations to be made prior to generating the report. Most of this has been automated through a web system I have created. Each report is different as it is based on each candidates psych testing results.
Manually entering this could result in user error.

I could create the report in excel however this isn't ideal.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge Macro	ch1325	Word VBA	2	06-08-2015 06:18 AM
Mail Merge Macro	spc94	Word VBA	2	06-04-2015 07:06 AM
Help Please: New VBA user trying to use a macro to split Mail Merge documents. Two Run-Time Error	zipit189	Word VBA	7	03-18-2015 01:13 PM
Macro to loop through all cells in a table produced by a mail merge	elh52	Word VBA	4	08-31-2014 10:50 PM
Word Doc Macro (mail Merge)	ajolson1964	Word VBA	1	05-10-2011 10:15 PM