Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-29-2013, 08:22 PM
macropod's Avatar
macropod macropod is online now TextFields disappear during mail merge Windows 7 32bit TextFields disappear during mail merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,526
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

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
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 09-30-2013, 07:51 AM
Cosmo Cosmo is offline TextFields disappear during mail merge Windows Vista TextFields disappear during mail merge Office 2007
Competent Performer
TextFields disappear during mail merge
 
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
TextFields disappear during mail merge merge fields disappear in merge doc but prints mdod Word 1 07-19-2013 06:33 PM
Mail Merge Duplication of address on merge RICKY Mail Merge 1 09-26-2012 03:14 PM
TextFields disappear during mail merge Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM
TextFields disappear during mail merge Color in textfields darker/more intense than object paulie_k PowerPoint 3 12-13-2011 09:21 AM
TextFields disappear during mail merge Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft