Thread: [Solved] Mail Merge keeping VBA Macro
View Single Post
 
Old 08-02-2015, 10:41 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,373
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Piney View Post
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote