User formfields reset when mailmerge document

[Doru Daroczi]

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

 

[Charles Kenyon]

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.
--
Charles 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.

 

[Doru Daroczi]

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

 

[Doug Robbins]

Ctrl+Shift+F9

--
Hope 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

 

[Doru Daroczi]

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

 

[Charles Kenyon]

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.
--
Charles 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.