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.
--
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" wrote in message
...
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

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

"Charles Kenyon" wrote in
message ...
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" wrote in message
...
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

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" wrote in message
...
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

"Charles Kenyon" wrote in
message ...
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" wrote in message
...
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

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


"Doug Robbins" wrote in message
...
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" wrote in message
...
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

"Charles Kenyon" wrote in
message ...
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" wrote in message
...
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

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.

"Doru Daroczi" wrote in message
...
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

"Charles Kenyon" wrote in
message ...
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" wrote in message
...
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