Reply
 
Thread Tools Display Modes
  #1   Report Post  
zSplash
 
Posts: n/a
Default Textboxes in Mailmerge?

Please excuse my ignorance -- mailmerge is completely new to me. So, if I
am trying to create a form that uses mailmerge to get fields from a data
source. Then, once the mailmerge has completed, I want to be able to
manually fill-in fields (i.e., textboxes, dropdown boxes in a non-mailmerge
form on a protected doc). Other than using "fill-in" fields (whose clunky
boxes are nerve-wracking), how can I incorporate text boxes in a mailmerge?

That is, in a regular document, I'd put in textboxes, and then protect the
document. As the user tabs through the document, he can replace the
textboxes with whatever he wants. Is there something similar in mailmerge??

TIA


  #2   Report Post  
zSplash
 
Posts: n/a
Default

I think I should have referred to "formfields" instead of "textboxes" in my
first post.

So, I use mailmerge to get fields from a data source. Then, once the
mailmerge has completed, I want to be able to manually fill-in fields
(i.e., formfields). Other than using "fill-in" fields (whose clunky
boxes are nerve-wracking), how can I incorporate
formfields in a mailmerge?

That is, in a regular document, I'd put in formfields, and then protect the
document. As the user tabs through the document, he can enter whatever
he wants in the formfields.

I have coded to do this using bookmarks, but is there something better?

TIA


  #3   Report Post  
Charles Kenyon
 
Posts: n/a
Default

Completing a mailmerge automatically gets rid of fields. The way I use
formfields and mailmerge together is to not complete the merge. I display
the merge on screen, protect the document for forms, and fill in the
formfields. I freeze the mergefields if I want to save the document. This
works for dealing with one record at a time, which is how I use mailmerge.
If you want to actually do a merge of many records, and have the same
information in your formfields for all records, I would recommend using my
method, freezing the formfields but not the mergefields and then performing
the merge.

Fill-in fields are designed for mailmerge. They let you vary your input for
each record. You are right, they are clunky.

Another method would be to put the paragraphs with your formfields in
AutoText (assuming no merge fields in said paragraphs). Then perform your
merge and after the merge, insert your formfields and protect the document.
Still very clunky.
--
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.

"zSplash" zNOSPAMSplash@ gci.net wrote in message
...
I think I should have referred to "formfields" instead of "textboxes" in my
first post.

So, I use mailmerge to get fields from a data source. Then, once the
mailmerge has completed, I want to be able to manually fill-in fields
(i.e., formfields). Other than using "fill-in" fields (whose clunky
boxes are nerve-wracking), how can I incorporate
formfields in a mailmerge?

That is, in a regular document, I'd put in formfields, and then protect
the
document. As the user tabs through the document, he can enter whatever
he wants in the formfields.

I have coded to do this using bookmarks, but is there something better?

TIA




  #4   Report Post  
zSplash
 
Posts: n/a
Default

Thanks, Charles. I guess I'm just too ignorant -- what do you mean by "not
complete the merge" or "freeze the mergefields..." or "freeze the formfields
but not the mergefields and then performing the merge"?

st.
"Charles Kenyon" wrote in
message ...
Completing a mailmerge automatically gets rid of fields. The way I use
formfields and mailmerge together is to not complete the merge. I display
the merge on screen, protect the document for forms, and fill in the
formfields. I freeze the mergefields if I want to save the document. This
works for dealing with one record at a time, which is how I use mailmerge.
If you want to actually do a merge of many records, and have the same
information in your formfields for all records, I would recommend using my
method, freezing the formfields but not the mergefields and then

performing
the merge.

Fill-in fields are designed for mailmerge. They let you vary your input

for
each record. You are right, they are clunky.

Another method would be to put the paragraphs with your formfields in
AutoText (assuming no merge fields in said paragraphs). Then perform your
merge and after the merge, insert your formfields and protect the

document.
Still very clunky.
--
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.

"zSplash" zNOSPAMSplash@ gci.net wrote in message
...
I think I should have referred to "formfields" instead of "textboxes" in

my
first post.

So, I use mailmerge to get fields from a data source. Then, once the
mailmerge has completed, I want to be able to manually fill-in fields
(i.e., formfields). Other than using "fill-in" fields (whose clunky
boxes are nerve-wracking), how can I incorporate
formfields in a mailmerge?

That is, in a regular document, I'd put in formfields, and then protect
the
document. As the user tabs through the document, he can enter whatever
he wants in the formfields.

I have coded to do this using bookmarks, but is there something better?

TIA






  #5   Report Post  
Charles Kenyon
 
Posts: n/a
Default

You can freeze or lock fields with their current results so that they won't
change even if the data is changed or disconnected. With the form
unprotected, right-click on the fields involved and lock them individually.
(This can be done with a macro but I'm doubt you are up to writing it. You
could get help in the vba beginners group. You would want to lock only
mergefields or only formfields.)

To get merge results into a document with active formfields, you set up the
merge and preview the results on screen using the ABC button on the merge
toolbar. At this point, you haven't "performed the merge" but you have a
document that looks like you have. At that point you could lock the merge
fields and save your result document. Then, independent of mailmerge, you
protect it for forms and fill in your formfields. This is the method I use,
but I am only preparing documents based on a single record.

If, on the other hand, you are doing merges of multiple records but the
information in the formfields will be the same for all of the records, you
could lock your primary merge document for forms, fill in the form fields,
unlock the form and lock the formfields and then actually run a merge for
the multiple records. I suspect that using ASK or fill-in fields would be
more productive, though, especially if your formfield info changes for
different records.

Probably clear as mud. Sorry, but I've got to get back to my paying work.
--
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.


"zSplash" zNOSPAMSplash@ gci.net wrote in message
...
Thanks, Charles. I guess I'm just too ignorant -- what do you mean by
"not
complete the merge" or "freeze the mergefields..." or "freeze the
formfields
but not the mergefields and then performing the merge"?

st.
"Charles Kenyon" wrote in
message ...
Completing a mailmerge automatically gets rid of fields. The way I use
formfields and mailmerge together is to not complete the merge. I display
the merge on screen, protect the document for forms, and fill in the
formfields. I freeze the mergefields if I want to save the document. This
works for dealing with one record at a time, which is how I use
mailmerge.
If you want to actually do a merge of many records, and have the same
information in your formfields for all records, I would recommend using
my
method, freezing the formfields but not the mergefields and then

performing
the merge.

Fill-in fields are designed for mailmerge. They let you vary your input

for
each record. You are right, they are clunky.

Another method would be to put the paragraphs with your formfields in
AutoText (assuming no merge fields in said paragraphs). Then perform your
merge and after the merge, insert your formfields and protect the

document.
Still very clunky.
--
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.

"zSplash" zNOSPAMSplash@ gci.net wrote in message
...
I think I should have referred to "formfields" instead of "textboxes" in

my
first post.

So, I use mailmerge to get fields from a data source. Then, once the
mailmerge has completed, I want to be able to manually fill-in fields
(i.e., formfields). Other than using "fill-in" fields (whose clunky
boxes are nerve-wracking), how can I incorporate
formfields in a mailmerge?

That is, in a regular document, I'd put in formfields, and then protect
the
document. As the user tabs through the document, he can enter whatever
he wants in the formfields.

I have coded to do this using bookmarks, but is there something better?

TIA










  #6   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi ZSplash,

This problem, and way to work around it, is described in the KB article

WD2000: Text Form Fields Are Not Retained During Mail Merge
http://support.microsoft.com?kbid=211308

Please excuse my ignorance -- mailmerge is completely new to me. So, if I
am trying to create a form that uses mailmerge to get fields from a data
source. Then, once the mailmerge has completed, I want to be able to
manually fill-in fields (i.e., textboxes, dropdown boxes in a non-mailmerge
form on a protected doc). Other than using "fill-in" fields (whose clunky
boxes are nerve-wracking), how can I incorporate text boxes in a mailmerge?

That is, in a regular document, I'd put in textboxes, and then protect the
document. As the user tabs through the document, he can replace the
textboxes with whatever he wants. Is there something similar in mailmerge??


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems (again) getting Outlook contacts in Word 2002 Mailmerge Carl Mailmerge 1 January 21st 05 03:13 AM
Mailmerge in Word, date format in merged doc brownsox Mailmerge 2 January 14th 05 01:29 PM
MailMerge Data Sources Bill S. Mailmerge 1 January 8th 05 11:07 AM
Included Property in Word 2003 MailMerge Alessio Mailmerge 1 December 23rd 04 12:26 PM
How to update envelop mailmerge input from outlook jam Mailmerge 1 December 9th 04 08:49 AM


All times are GMT +1. The time now is 04:39 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"