 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / September 2005User formfields reset when mailmerge document
Hello, I have created a form to send to users and used formfields for them to enter data. My plan was to do a mailmerge using this form once I get it back from users. For some reason the formfields are reset by word once I select my data source. Any help would be greatly appreciated as I am in desperate need for a solution. Note: I found a solution to avoid field reset when protecting/unprotecting forms but that does not help with this. Many thanks, Doru Formfields and mailmerge are fundamentally incompatible in Word. You could perhaps unlink the formfields once the form is returned to you and then perform your mailmerge.  SignatureCharles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. > Hello, > [quoted text clipped - 15 lines] > Many thanks, > Doru Thanks for feedback Charles. What do you mean by unlink the formfields? I currently found the following workaround: - before doing the mailmerge I am running a small macro that takes each formfield content and makes it the default text value for that specific formfield. This way, the content is kept when running the mailmerge. Cheers, Doru > Formfields and mailmerge are fundamentally incompatible in Word. You could > perhaps unlink the formfields once the form is returned to you and then [quoted text clipped - 18 lines] >> Many thanks, >> Doru Ctrl+Shift+F9 SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > Thanks for feedback Charles. > [quoted text clipped - 30 lines] >>> Many thanks, >>> Doru That is a great trick. Thanks. Unfortunatelly I have about 20 fields on a form and the forms keep on flowing in. I needed something more automatic and the macro does the trick. I will however redesign the whole form at next occasion. Cheers, Doru > Ctrl+Shift+F9 > [quoted text clipped - 32 lines] >>>> Many thanks, >>>> Doru If your macro is giving you the default value for each field, why bother sending it out at all? If it is giving you the current value, that is the equivalent of unlinking the field. SignatureCharles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://www.mvps.org/word which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. > Thanks for feedback Charles. > [quoted text clipped - 30 lines] >>> Many thanks, >>> Doru |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.