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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mergo to fields
Hi,
I build a form I locked and would like to merge and use the merged data as default value for each field of the form (or fill i nthe form with the imported data). I tried to set the default value of the fields to = { MERGEFIELD Name } but it does not work. I tried some macro too but failed. Thanks PS : Word 2000 |
#2
|
|||
|
|||
In Word 2000 the only way you could really do this would be to write a macro
that fills in the data and produces an output document for each record in the data source. It wouldn't actually be a Word merge, but you could use the MailMerge.DataSource.DataFields collection to get the values of the various fields and insert them into your form. Alternatively you could (and probably should) avoid MailMerge altogether and just use ADO or some other interface to get your data and do the same thing. I don't have sample code for that. In Word 2002 or later you might be able to use the mail merge events to do something similar. However, just merging to an output file may not be what you really want to do anyway - if you do not want to preserve the form fields for use by other people, there would be no real need to use Form fields. If you do want to preserve the form fields, you would also probably be better off generating forms anf accompanying data from scratch in VBA. Peter Jamieson "Jonathan" wrote in message ... Hi, I build a form I locked and would like to merge and use the merged data as default value for each field of the form (or fill i nthe form with the imported data). I tried to set the default value of the fields to = { MERGEFIELD Name } but it does not work. I tried some macro too but failed. Thanks PS : Word 2000 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
improving performance by indexing query criteria fields | Paul James | General Discussion | 20 | February 16th, 2005 07:55 PM |
improving performance by indexing query criteria fields | Paul James | Running & Setting Up Queries | 20 | February 16th, 2005 07:55 PM |
adding 2 fields including null entries | Jesse | Running & Setting Up Queries | 26 | January 18th, 2005 05:31 PM |
Can't Add Fields to Form | Jeff Miller | Using Forms | 4 | January 12th, 2005 03:42 AM |
Automatic filling of fields in table two from table one | Jim Kelly | Database Design | 1 | September 27th, 2004 10:16 PM |