View Single Post
 
Old 09-30-2013, 07:51 AM
Cosmo Cosmo is offline Windows Vista Office 2007
Competent Performer
 
Join Date: Mar 2012
Posts: 240
Cosmo is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Basically, mailmerge is incompatible with formfields. See: http://support.microsoft.com/kb/286841
For a workaround, see: http://www.gmayor.com/Form_Fields_and_Mail_Merge.htm
Thanks, I had suspected as much. I just found it odd that the text fields are removed, but other form fields are retained. I'm looking into the links you provided, to see if they will solve the issues I'm having.

I haven't had the chance to test moving the section of the mail merge that has form fields to a separate document yet, I am wondering if you know whether or not the Text Field form fields will be stripped out if I add that section back in during the MailMergeAfterRecordMerge event? Or do I need to add that section, keep track of each range as it's added, then restore the form fields to those ranges after the merge is completed?

Another incompatibility I came across is that the form fields lose their values when the Mail Merge reaches the 'Select Recipients' step, so I have to store and reset their values at the appropriate times. I believe I have this partially working. I did a test using one of the form fields and resetting it's value after the merge, and that seemed to work, so I created a function to loop through all form fields on the cover page and reset their values. I believe this will do what I want, although I still need to investigate to make sure it works when it needs to.
Reply With Quote