Mergo to fields

J

Jonathan

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
 
P

Peter Jamieson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top