A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Legacy Text Control Won't Merge in Word 2007



 
 
Thread Tools Display Modes
  #1  
Old August 4th, 2009, 10:53 PM posted to microsoft.public.word.mailmerge.fields
Chris Thacker
external usenet poster
 
Posts: 1
Default Legacy Text Control Won't Merge in Word 2007

I have created a document that merges with an Access Database. In that
document I have inserted several 'merged' fields. In addition to the merged
fields I have inserted several legacy controls including a drop list, check
box, and text fields. When I merge the document with a particular record
from my database, then edit that specific document I find that although my
check box and drop list controls move over to the new merged document along
with the data from the database, the legacy text box is stripped from the
master document. I am able to insert an active x text field, and protect the
new document to be used as a form but am not able to format or control the
text box behavior so that it will grow with the amount of text entered or be
limited to a text only field, date format field, or a numeric only field as I
could with the legacy text control. Is there a way to merge a document with
legacy controls that does not lose the text box?
  #2  
Old August 4th, 2009, 11:19 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Legacy Text Control Won't Merge in Word 2007

See the article “Combining FormFields and Mail Merge” on the following page
of fellow MVP Graham Mayor’s website:

http://www.gmayor.com/Form_Fields_and_Mail_Merge.htm

If that information is of use to you, please do consider contributing to the
maintenance of that website to ensure its continued availability.


--
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, originally posted via msnews.microsoft.com
"Chris Thacker" Chris wrote in message
...
I have created a document that merges with an Access Database. In that
document I have inserted several 'merged' fields. In addition to the
merged
fields I have inserted several legacy controls including a drop list,
check
box, and text fields. When I merge the document with a particular record
from my database, then edit that specific document I find that although my
check box and drop list controls move over to the new merged document
along
with the data from the database, the legacy text box is stripped from the
master document. I am able to insert an active x text field, and protect
the
new document to be used as a form but am not able to format or control the
text box behavior so that it will grow with the amount of text entered or
be
limited to a text only field, date format field, or a numeric only field
as I
could with the legacy text control. Is there a way to merge a document
with
legacy controls that does not lose the text box?


  #3  
Old August 5th, 2009, 01:26 PM posted to microsoft.public.word.mailmerge.fields
Chris Thacker[_2_]
external usenet poster
 
Posts: 1
Default Legacy Text Control Won't Merge in Word 2007

Thank you for the assistance Doug and were I smart enough to understand what
the link is explaining it might well work. However the instructions for a
lay person such as myself kind of go over my head. There was not enough
specific instruction on how to set up the document in the linked page for me
to execute the process as described on MVP Graham Mayor's website.

"Doug Robbins - Word MVP" wrote:

See the article “Combining FormFields and Mail Merge” on the following page
of fellow MVP Graham Mayor’s website:

http://www.gmayor.com/Form_Fields_and_Mail_Merge.htm

If that information is of use to you, please do consider contributing to the
maintenance of that website to ensure its continued availability.


--
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, originally posted via msnews.microsoft.com
"Chris Thacker" Chris wrote in message
...
I have created a document that merges with an Access Database. In that
document I have inserted several 'merged' fields. In addition to the
merged
fields I have inserted several legacy controls including a drop list,
check
box, and text fields. When I merge the document with a particular record
from my database, then edit that specific document I find that although my
check box and drop list controls move over to the new merged document
along
with the data from the database, the legacy text box is stripped from the
master document. I am able to insert an active x text field, and protect
the
new document to be used as a form but am not able to format or control the
text box behavior so that it will grow with the amount of text entered or
be
limited to a text only field, date format field, or a numeric only field
as I
could with the legacy text control. Is there a way to merge a document
with
legacy controls that does not lose the text box?



  #4  
Old August 5th, 2009, 02:17 PM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Legacy Text Control Won't Merge in Word 2007

As the page explains, form fields and mail merge fields are mutually
exclusive. The macros included on the page -
(http://www.gmayor.com/installing_macro.htm explains how to install macros
from listings) convert the mail merge fields to docvariable fields leaving
the form fields and the docvariable fields are populated from the data
source. You therefore end up with a collection of protected forms one for
each record, filled with data specific to the records in your data source
(three fields in the example) and with user fillable form fields.

Attach your data source to the protected form and run the appropriate macro.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Chris Thacker wrote:
Thank you for the assistance Doug and were I smart enough to
understand what the link is explaining it might well work. However
the instructions for a lay person such as myself kind of go over my
head. There was not enough specific instruction on how to set up the
document in the linked page for me to execute the process as
described on MVP Graham Mayor's website.

"Doug Robbins - Word MVP" wrote:

See the article "Combining FormFields and Mail Merge" on the
following page of fellow MVP Graham Mayor's website:

http://www.gmayor.com/Form_Fields_and_Mail_Merge.htm

If that information is of use to you, please do consider
contributing to the maintenance of that website to ensure its
continued availability.


--
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, originally posted via msnews.microsoft.com
"Chris Thacker" Chris wrote in
message ...
I have created a document that merges with an Access Database. In
that document I have inserted several 'merged' fields. In addition
to the merged
fields I have inserted several legacy controls including a drop
list, check
box, and text fields. When I merge the document with a particular
record from my database, then edit that specific document I find
that although my check box and drop list controls move over to the
new merged document along
with the data from the database, the legacy text box is stripped
from the master document. I am able to insert an active x text
field, and protect the
new document to be used as a form but am not able to format or
control the text box behavior so that it will grow with the amount
of text entered or be
limited to a text only field, date format field, or a numeric only
field as I
could with the legacy text control. Is there a way to merge a
document with
legacy controls that does not lose the text box?



  #5  
Old August 5th, 2009, 09:31 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Legacy Text Control Won't Merge in Word 2007

With your existing mail merge main document, which you have protected to
allow only the filling in of forms as the active document, in your case, as
your data source is from Access, you would run a macro containing the code
under the heading on the website of Access Data Source.

If you do not know what to do with the code under that heading, see the
following page of that website http://www.gmayor.com/installing_macro.htm

--
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, originally posted via msnews.microsoft.com
"Chris Thacker" wrote in message
...
Thank you for the assistance Doug and were I smart enough to understand
what
the link is explaining it might well work. However the instructions for a
lay person such as myself kind of go over my head. There was not enough
specific instruction on how to set up the document in the linked page for
me
to execute the process as described on MVP Graham Mayor's website.

"Doug Robbins - Word MVP" wrote:

See the article “Combining FormFields and Mail Merge” on the following
page
of fellow MVP Graham Mayor’s website:

http://www.gmayor.com/Form_Fields_and_Mail_Merge.htm

If that information is of use to you, please do consider contributing to
the
maintenance of that website to ensure its continued availability.


--
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, originally posted via msnews.microsoft.com
"Chris Thacker" Chris wrote in
message
...
I have created a document that merges with an Access Database. In that
document I have inserted several 'merged' fields. In addition to the
merged
fields I have inserted several legacy controls including a drop list,
check
box, and text fields. When I merge the document with a particular
record
from my database, then edit that specific document I find that although
my
check box and drop list controls move over to the new merged document
along
with the data from the database, the legacy text box is stripped from
the
master document. I am able to insert an active x text field, and
protect
the
new document to be used as a form but am not able to format or control
the
text box behavior so that it will grow with the amount of text entered
or
be
limited to a text only field, date format field, or a numeric only
field
as I
could with the legacy text control. Is there a way to merge a document
with
legacy controls that does not lose the text box?




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.